You administer a Microsoft SQL Server 2012 server that has SQL Server Integration Services (SSIS) installed.
You plan to deploy new SSIS packages to the server.The SSIS packages use the Project Deployment Model
together with parameters and Integration Services environment variables. You need to configure the SQL
Server environment to support these packages. 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 stringpackage 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?

You are developing a SQL Server Integration Services (SSIS) package to load data into a SQL Server table on
Server A. The package includes a data flow and is executed on ServerB. The destination table has its own
identity column. The destination data load has the following requirements:
The identity values from the source table must be used.
Default constraints on the destination table must be ignored.
Batch size must be 100,000 rows.
You need to add a destination and configure it to meet the requirements. Which destination should you use?

You are creating a SQL Server Master Data Services (MDS) model for a company. The source data for the
company is stored in a single table that contains the manager-to-subordinate relationships. You need to create
a hierarchy representing the organizational structure of the company. Which hierarchy type 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 FuzzyLookup
similarity threshold is 0.50. Many values are incorrectly matched. You need to ensure that more accurate
matches are made by the Fuzzy Lookup transformationwithout degrading performance. What should you do?

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 FuzzyLookup
similarity threshold is 0.50. Many values are incorrectly matched. You need to ensure that more accurate
matches are made by the Fuzzy Lookup transformationwithout degrading performance. What should you do?

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 tablehas
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?

You are designing a SQL Server Integration Services(SSIS) data flow to load sales transactions from asource
system into a data warehouse hosted on SQL Azure. One of the columns in the data source is named
ProductCode. Some of the data to be loaded will reference products that need special processing logic in the
data flow. You need to enable separate processing streams for a subset of rows based on the source product
code. Which data flow transformation should you use?

You are designing a SQL Server Integration Services(SSIS) package that uses the Fuzzy Lookup
transformation. The reference data to be used in the transformation does not change. You need to reusethe
Fuzzy Lookup match index to increase performance and reduce maintenance. What should you do?