HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL
task in the package checks product stock levels and sets a package variable named InStock
to TRUE or FALSE depending on the stock level found.
After the successful execution of the Execute SQL task, one of two data flow tasks must run,
depending on the value of the InStock variable.
You need to set the precedence constraints.
Which value for the evaluation operation should you use? (To answer, select the appropriate
option for the evaluation operation in the answer area.)

DRAG DROP

You are loading a dataset into SQL Server. The dataset contains numerous duplicates for
the Artist and Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist
domain in the knowledge base. The values in the Song column in the dataset can be a close
match with the values in the Song domain.
You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to
identify duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the
answer area.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains several tasks that must repeat until an expression evaluates to
FALSE.
You need to add and configure a container to enable this design.
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,)

DRAG DROP

You are developing a SQL Server Integration Services (SSIS) package that loads data into a
data warehouse hosted on Windows Azure SQL Database.
You must combine two data sources together by using the ProductID column to provide
complete details for each record. The data retrieved from each data source is sorted in
ascending order by the ProductID column.
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.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package that downloads data
from a Windows Azure SQL Database database.
A stored procedure will be called in an Execute SQL task by using an ODBC connection.
This stored procedure has only the @CustomerID parameter of type INT.
A project parameter named CustID will be mapped to the stored procedure parameter
@CustomerID.
You need to ensure that the value of the CustID parameter is passed to the @CustomerID
stored procedure parameter.
In the Parameter Mapping tab of the Execute SQL task editor, how should you configure the
parameter? (To answer, drag the appropriate option or options to the correct location or
locations in the answer area.)

You are deploying a new SQL Server Integration Services (SSIS) package to several
servers.
The package must meet the following requirements:
.NET Common Language Runtime (CLR) integration in SQL Server must not be enabled.

The Connection Managers used in the package must be configurable without editing the
package.
The deployment procedure must be automated as much as possible.
You need to set up a deployment strategy that meets the requirements.
What should you do?