To ease the debugging of packages, you standardize the SQL Server Integration Services (SSIS)
package logging methodology. The methodology has the following requirements:
• Centralized logging in SQL Server
• Simple deployment
• Availability of log information through reports or T-SQL
• Automatic purge of older log entries
• Configurable log details
You need to configure a logging methodology that meets the requirements while minimizing the
amount of deployment and development effort. What should you do?

You are developing a SQL Server Integration Services (SSIS) package. To process complex scientific
data originating from a SQL Azure database, a custom task component is added to the project. You
need to ensure that the custom component is deployed on a test environment correctly. What
should you do?

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 developing a SQL Server Integration Services (SSIS) project that copies a large amount of
rows from a SQL Azure database, The project uses the Package Deployment Model. This project is
deployed to SQL Server on a test server. You need to ensure that the project is deployed to the SSIS
catalog on the production server. What should you do?

You are developing a SQL Server Integration Services (SSIS) package that imports data into a data
warehouse. You add an Execute SQL task to the control flow. The task must execute a simple INSERT
statement. The task has the following requirements:
• The INSERT statement must use the value of a string package variable. The variable name is
StringVar.

• The Execute SQL task must use an OLE DB Connection Manager.
In the Parameter Mapping tab of the Execute SQL task, StringVar has been added as the only
parameter. You must configure the SQLStatement property of the Execute SQL task. Which SQL
statement should you use?

DRAG DROP
You are designing an extract, transform, load (ETL) process with SQL Server Integration Services
(SSIS). Two packages, Package A and Package B, will be designed. Package A will execute Package B.
Both packages must reference a file path corresponding to an input folder where files will be located
for further processing. You need to design a solution so that the file path can be easily configured
with the least administrative and development effort. Which four 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 editing a SQL Server Integration Services (SSIS) package that contains three Execute SQL
tasks and no other tasks. The package and all three Execute SQL tasks have their TransactionOption
property set to Supported. You need to ensure that if any of the Execute SQL tasks fail, all three
tasks will roll back their changes. What should you do?

DRAG DROP
You are building a SQL Server Integration Services (SSIS) package to load data from all files that are
automatically copied to a directory each night through an external FTP process. You need to load
data from all copied files to a destination table in SQL Server. 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.)

You are designing a SQL Server Integration Services (SSIS) package that uploads a file to a table
named Orders in a SQL Azure database. The company’s auditing policies have the following
requirements:
• An entry must be written to a dedicated SQL Server log table named OrderLog.
• The entry must be written as soon as the file upload task completes.
You need to meet the company’s policy requirements. Which event handler should you use?

You are developing a SQL Server Integration Services (SSIS) package that imports data from a
relational database to a data warehouse. You are importing data from a relational table named
Projects. The table has change data capture enabled on all columns. You need to process only the
most recent values from rows that have been inserted or updated since the previous execution of
the package. Which query should you use as the data source?