You are editing a SQL Server Integration Services (SSIS) package that contains a task with a sensitive
property. You need to create a project parameter and configure it so that its value is encrypted when it is
deployed to the SSIS catalog. Which three steps should you perform in sequence? (To answer, move the
appropriate actions from the list of actions to theanswer area and arrange them in the correct order.)

A SQL Server Integration Services (SSIS) project has been deployed to the SSIS catalog. The project
includes a project Connection Manager to connect tothe data warehouse. The SSIS catalog includes
two Environments:
• Development
• QA
Each Environment defines a single Environment Variable named ConnectionString of type string. The
value of each variable consists of the connection string to the development or QA data warehouses.
You need to be able to execute deployed packages byusing either of the defined Environments.
Which three actions 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.)

You are validating whether a SQL Server IntegrationServices (SSIS) package named Master.dtsx in the SSIS
catalog is executing correctly. You need to displaythe number of rows in each buffer passed between each
data flow component of the package. Which three actions should you perform in sequence? (To answer, move
the appropriate actions from the list of actions tothe answer area and arrange them in the correct order.)

You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment model.
You need to monitor control flow tasks to determinewhether any of them are running longer than usual.Which
three actions 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.)

A Data Flow task in a SQL Server Integration Services (SSIS) package produces run- time errors. You need to
edit the package to log specific error messages. Which three actions 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.)

You are developing a SQL Server Integration Services (SSIS) project by using the Project Deployment model.
The project contains many packages. It is deployed on a server named SQLTest1. The project will be deployed
to several servers that run SQL Server 2012. The project accepts one required parameter. The data typeof the
parameter is a string. A SQL Agent job is created that will call the Loading.dtsx package in the project. A job
step is created for the SSIS package. The job must pass the value of an SSIS Environment Variable to the
project parameter. The value of the Environment Variable must be configured differently on each serverthat
runs SQL Server. The value of the Environment Variable must provide the server name to the project
parameter. You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the
package. Which four actions should you perform in sequence by using SQL Server Management Studio? (To
answer, move the appropriate actions from the list of actions to the answer area and arrange them in the
correct order.)

You are designing a SQL Server Integration Services(SSIS) package. The package moves order-related data
to a staging table named Order. Every night the staging data is truncated and then all the recent orders from
the online store database are inserted into the staging table. Your package must meet the following
requirements:
If the truncate operation fails, the package execution must stop and report an error.
If the Data Flow task that moves the data to the staging table fails, the entire refresh operation must be
rolled back.
For auditing purposes, a log entry must be entered in a SQL log table after each execution of the DataFlow
task.
The TransactionOption property for the package is set to Required. You need to design the package to meet
the requirements. How should you design the controlflow for the package? (To answer, drag the appropriate
setting from the list of settings to the correct location or locations in the answer area.)

You are developing a SQL Server Integration Services (SSIS) package to insert new data into a data mart. The
package uses a Lookup transformation to find matches between the source and destination. The data flowhas
the following requirements:
New rows must be inserted.
Lookup failures must be written to a flat file.
In the Lookup transformation, the setting for rows with no matching entries is set to Redirect rows tono match
output. You need to configure the package to directdata into the correct destinations. How should youdesign
the data flow outputs? (To answer, drag the appropriate transformation from the list of answer optionsto the
correct location in the answer area.)

You are building a SQL Server Integration Services (SSIS) package to load product data sourced from a SQL
Azure database to a data warehouse. Before the product data is loaded, you create a batch record by using an
Execute SQL task named Create Batch. After successfully loading the product data, you use another Execute
SQL task named Set Batch Success to mark the batch as successful.

You need to create and execute an Execute SQL task to mark the batch as failed if either the Create Batch or
Load Products task fails. Which three steps should you perform in sequence? (To answer, move the
appropriate actions from the list of actions to theanswer area and arrange them in the correct order.)

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 CountryCodecolumn 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.)