HOTSPOT
You are editing a SQL Server Integration Services (SSIS) package.
You need to edit the Script task that has an expression defined.
Which task should you select? To answer, select the appropriate setting or settings in the answer area.

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a
source system into a data warehouse hosted on SQL Azure. One of the columns in the data source is
named ProductCode.
Some of the data to be loaded will reference products that need special processing logic in the data
flow.
You need to enable separate processing streams for a subset of rows based on the source product code.
Which data flow transformation should you use?

You are developing a data flow transformation to merge two data sources. One source contains product
data and the other source contains data about the country in which the product was manufactured.
Both data sources contain a two-character CountryCode column and both use SQL Server. Both data
sources contain an ORDER BY clause to sort the data by the CountryCode column in ascending order.
You use a Merge Join transformation to join the data.

You need to ensure that the Merge Join transformation works correctly without additional
transformations. What should you do? (Each answer presents a part of the solution. Choose all that
apply.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that imports unsorted data into a
data warehouse hosted on SQL Azure.
You have the following requirements:
• A destination table must contain all of the data in two source tables.
• Duplicate records must be inserted into the destination table.
You need to develop a data flow that imports the data while meeting the requirements.
How should you develop the data flow? (To answer, drag the appropriate transformation from the list of
transformations to the correct location in the answer area.)

You are developing a SQL Server Integration Services (SSIS) package.
The package is stored as the myPackage.dtsx file in the root directory of the C drive of the SSIS server.
You need to run the package from the command prompt.
Which command should you use?

HOTSPOT
You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools.
A package Connection Manager has been parameterized with project scope.
You need to display the parameters that have been generated for the Connection Manager.
What should you use? To answer, select the appropriate setting or settings in the answer area.

You are troubleshooting an existing SQL Server Integration Services (SSIS) package. On several occasions,
the package execution does not finish and no data seems to have been transferred.
You need to ensure that package logging occurs. Your solution must minimize deployment and
development efforts.
What should you do?

You are implementing a SQL Server Integration Services (SSIS) package that loads data hosted in a SQL
Azure database into a data warehouse.
The source system contains redundant or inconsistent data. When the package finds invalid data, the
row containing the invalid data must be omitted but it must also be written to a text file for further
analysis.
You need to establish the best technique to log these invalid rows while keeping the amount of
development effort to a minimum.
What should you do?

You install a SQL Server 2012 database engine instance on a production server. A month later, you install
SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project Deployment model.
Operations log records that are outside the configured retention period must be cleaned automatically.
You need to create the SSIS catalog on the production server and ensure that the operations log
cleaning requirement is met.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that is ready for deployment to a
production server. The package contains sensitive information secured by using the
EncryptSensitiveWithUserKey package protection level.
You are preparing the package for deployment by the production operations team.You need to ensure that the production operations team can open and execute the package without reentering the sensitive information.
Which three steps should you perform in sequence? (To answer, move the appropriate actions from the
list of actions to the answer area and arrange them in the correct order.)