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,)

You are designing a data warehouse with two fact tables. The first table contains sales per
month and the second table contains orders per day.
Referential integrity must be enforced declaratively.
You need to design a solution that can join a single time dimension to both fact tables.
What should you do?

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?

You maintain a SQL Server Integration Services (SSIS) package. The package was
developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?

You administer a SQL Server Integration Services (SSIS) solution in the SSIS catalog. A
SQL Server Agent job is used to execute a package daily with the basic logging level.
Recently, the package execution failed because of a primary key violation when the package
inserted data into the destination table.
You need to identify all previous times that the package execution failed because of a
primary key violation.
What should you do?

You are developing a SQL Server Integration Services (SSIS) package to load data into a
Windows Azure SQL Database database. The package consists of several data flow tasks.
The package has the following auditing requirements:
If a data flow task fails, a Transact-SQL (T-SQL) script must be executed.
The T-SQL script must be executed only once per data flow task that fails, regardless of the
nature of the error.
You need to ensure that auditing is configured to meet these requirements.
What should you do?

You are developing a SQL Server Integration Services (SSIS) project with multiple packages
to copy data to a Windows Azure SQL Database database.
An automated process must validate all related Environment references, parameter data
types, package references, and referenced assemblies. The automated process must run on
a regular schedule.
You need to establish the automated validation process by using the least amount of
administrative effort.
What should you do?

You are developing a SQL Server Integration Services (SSIS) project by using the Project
Deployment Model. All packages in the project must log custom messages.
You need to produce reports that combine the custom log messages with the systemgenerated log messages. What should you do?

You are developing a SQL Server Integration Services (SSIS) package to implement an
incremental data load strategy. The package reads data from a source system that uses the
SQL Server change data capture (CDC) feature.
You have added a CDC Source component to the data flow to read changed data from the
source system.
You need to add a data flow transformation to redirect rows for separate processing of
insert, update, and delete operations.
Which data flow transformation should you use?

A SQL Server Integration Services (SSIS) package imports daily transactions from several
files into a SQL Server table named Transaction. Each file corresponds to a different store
and is imported in parallel with the other files. The data flow tasks use OLE DB destinations
in fast load data access mode.
The number of daily transactions per store can be very large and is growing- The
Transaction table does not have any indexes.
You need to minimize the package execution time.
What should you do?