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 readingcommitted 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 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 canbe easily configured with the least administrativeand
development effort. Which four actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer areaand arrange them in the correct order.)

A SQL Server Integration Services (SSIS) package named DataFeed interacts with an external vendor data
feed. The package is executed several times a day, either as part of other packages’ control flow or by itself.
The external data feed is unreliable because network failures and slow response times are frequent. The
package is currently deployed on the file system. To analyze the reliability of the external data feed, you must
collect execution data. Every time the DataFeed package is executed, the following information must be
logged:
• Start Time
• End Time
• Execution Result
• Execution Duration
You need to design a logging solution that meets the requirements by using the least amount of administrative
and development effort. Which three actions 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 use SQL Server Integration Services (SSIS) for extract, transformation, load (ETL) processing.
Issues concerning addresses are discovered in the data warehouse that you manage. Validation must
separate the addresses into three categories:
• Valid addresses
• Autocorrected addresses
• Invalid addresses
You need to enhance the SSIS packages to perform address validation by using an external service.
Which transformation should you use? (To answer, drag the appropriate transformation from the list
of options to the correct location or locations in the answer area.)

You are designing a SQL Server Integration Services(SSIS) package configuration strategy. The package
configuration must meet the following requirements:
• Include multiple properties in a configuration.
• Support several packages with different configuration settings.
You need to select the appropriate configuration. Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.

You are designing a SQL Server Integration Services(SSIS) package configuration strategy. The package
configuration must meet the following requirements:
• Include multiple properties in a configuration.
• Force packages to load all settings in the configuration.
• Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration. Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.

You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accessesa SQL Server database.
The custom functionality must be implemented by using Language Integrated Query (LINQ).
You need to ensure that the LINQ code can be debugged at design time.
What should you select from the SSIS Toolbox? (To answer, drag the appropriate item to the correct location in
the answer area.)

You are editing a SQL Server Integration Services (SSIS) package. You need to edit the Script task that has an
expression defined. Which task should you select? To answer, select the appropriate setting or settings in the
answer area.

You are editing a SQL Server Integration Services (SSIS) project named Project1 in SQL Server Data Tools. A
package Connection Manager has been parameterized with project scope. You need to display the parameters
that have been generated for the Connection Manager. What should you use? To answer, select the
appropriate setting or settings in the answer area.

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