What should you do?
You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. The
business model of the company uses SSIS. There are 30 packages that use the same
configuration and are stored in an XML file as a variable.
You want to track the changes that affect a package that uses one variable. You also want to
modify the package to provide automatic notification through email whenever there are changes to
the variable. What should you do?
Each correct answer represents a part of the solution. Choose all that apply.
which of the following roles should you be assigned to accomplish the task?
[tagged]
You are an employee at ABC.com. The company has a SQL Server 2008 computer. The SQL
Server 2008 Reporting Services instance is being administered in the company. You want to view
the basic information about the report server. To which of the following roles should you be
assigned to accomplish the task?
Which of the following SQL Server Integration Services transformations should you choose to accomplish the tas
[tagged]
You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
manage a SQL Server 2008 Integration Services (SSIS) package for the company. You want to
perform operations like mining text, cleaning data, and running data mining prediction queries.
Which of the following SQL Server Integration Services transformations should you choose to
accomplish the task?
what happened?
[tagged]
You work as an administrator for ABC.com. The company has a SQL Server 2008 computer. You
are assigned a task to create and maintain Microsoft SQL Server 2008 Integration Services (SSIS)
packages with the help of SSIS Designer. While you were developing the packages, it failed.
Which of the following tabs of the SSIS Designer should you look to identify what happened?
You need to make changes in the control flow designer to meet the requirements
You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
are designing a SQL Server 2008 Integration Services (SSIS) package. The package uses at least
one sequence container in one transaction. A Data Flow task and a Control Flow task are
controlled by each transaction. Each Data Flow task has a success constraint that is followed by
the Control Flow task. The following requirements should be included in the package:
Each Data Flow task must use its own transaction.
The Control Flow task and the Data Flow task that precedes it must fail or succeed as an atomic
unit.
A restart point must restart each Data Flow task and the Control Flow task that follows it as an
atomic unit.
You need to make changes in the control flow designer to meet the requirements. What should
you do?
Each correct answer represents a part of the solution. Choose all that apply.
Which of the following parameters of the mining model should you change to accomplish the task?
You work as an administrator for ABC.com. The company has a SQL Server 2008 computer. You
manage a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. You deploy a data
mining structure, which includes the Clustering mining model of Microsoft. You want to change the
mining model properties from Scalable K-Means to Non-scalable K-Means. Which of the following
parameters of the mining model should you change to accomplish the task?
Which of the following protection levels should you use?
You work as an Administrator for ABC.com. The company has a SQL Server 2008 computer. You
are creating a SQL Server 2008 Integration Services (SSIS) package. The package contains some
sensitive data that needs protection. In order to protect the package, you decide to encrypt the
entire package including the sensitive data. You provide a password to accomplish this. Which of
the following protection levels should you use?
What action should you do?
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
According to the requirement of the company, you’re deploying a SQL Server 2008 Integration Services (SSIS) package.
The XML configuration is not specified when deploying the package. You have to apply the configuration to the deployed package. What action should you do?
You must make sure that you can write the required information to the text file. So what action should you per
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008.
You work as the technical support. Now you get an order from your company CIO, you are asked to design a SQL Server 2008 Integration Services (SSIS) package.
The package contains an OnError event handler, a data flow task contained in a For Loop container, and a Flat File destination component which uses a Flat File connection manager.
When the package meets an error, from an expression that includes the version of the package, you intend to write diagnostic information to a text file.
You must make sure that you can write the required information to the text file. So what action should you perform?
So what action should you perform?
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server2008.
Now you are employed in a company named NaproStar which uses SQL Server2008. You work as the technical support.
The package includes several data flows. Now you receive an e-mail from your company CIO, according to his requirement, you have to make use of the Business Intelligence Development Studio to monitor the data that passes through each path in the data flow.
Besides this, the company CIO also wants the data flow logic is retained. You have to achieve this goal. So what action should you perform?