You are designing a package control flow. The package moves sales order data from a SQL Azure
transactional database to an on-premise reporting database. The package will run several times a
day, while new sales orders are being added to the transactional database. The current design of the
package control flow is shown in the answer area. (Click the Exhibit button.)

The Insert New Orders Data Flow task must meet the following requirements:
*Usage of the tempdb database should not be impacted.
*Concurrency should be maximized, while only reading committed transactions.
*If the task fails, only that task needs to be rolled back.
You need to configure the Insert New Orders Data Flow task to meet the requirements.
How should you configure the transaction properties? To answer, select the appropriate setting or
settings in the answer area.

You are designing a SQL Server Integration Services (SS1S) 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 into a data
warehouse hosted on SQL Azure. The package uses a Foreach container to process text files found in
a folder. The package must be deployed to a single server by using the Project Deployment model.
Multiple SQL Server Agent jobs call the package. Each job is executed on a different schedule. Each
job passes a different folder path to the package. You need to configure the package to accept the
folder path from each job. Which package configuration should you use?

You are developing a SQL Server Integration Services (SSIS) package to load data into a data warehouse.

You need to establish the correct order for loading each table to maximize parallel processing. Which
order should you use?

You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure data into a data
warehouse every night. The SQL Azure data contains many misspellings and variations of
abbreviations. To import the data, a developer used the Fuzzy Lookup transformation to choose the
closest-matching string from a reference table of allowed values. The number of rows in the
reference table is very large. If no acceptable match is found, the Fuzzy Lookup transformation
passes a null value. The current setting for the Fuzzy Lookup similarity threshold is 0.50. Many values
are incorrectly matched. You need to ensure that more accurate matches are made by the Fuzzy
Lookup transformation without degrading performance. What should you do?

Occasionally a job that executes an existing SQL Server Integration Services (SSIS) package does not
complete and nothing is processed. You need to ensure that package logging occurs. Your solution
must minimize deployment and development efforts. What should you do?

To facilitate the troubleshooting of SQL Server Integration Services (SSIS) packages, a logging
methodology is put in place. The methodology has the following requirements:
• The deployment process must be simplified.
• All the logs must be centralized in SQL Server.
• Log data must be available via reports or T-SQL.
• Log archival must be automated.
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 deploying a new SQL Server Integration Services (SSIS) project to the test environment. A
package in the project uses a custom task component. You need to ensure that the custom object is
deployed on the test environment correctly. What should you do?

You are deploying a project to the SQL Server Integration Services (SSIS) catalog. You need to ensure
that the project is deployed to the production environment with the least amount of administrative
effort. What should you do?

You are writing a SQL Server Integration Services (SSIS) package that transfers data from a legacy
system. Data integrity in the legacy system is very poor. Invalid rows are discarded by the package
but must be logged to a CSV file for auditing purposes. You need to establish the best technique to
log these invalid rows while minimizing the amount of development effort. What should you do?