HOTSPOT
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 designing a SQL Server Integration Services (SSIS) solution that will load multiple Online
Transactional Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
• Ensure that the process supports the creation of an exception report that details
possible duplicate key values, null ratios within columns, and column-length
distributions of values.
• Ensure that users can generate the exception report in an XML format.
• Use the minimum development effort.
You need to design the SSIS solution to meet the requirements. What should you do? (More than one
answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS
project that includes several SSIS packages. Each SSIS package will define the same connection managers
and variables.
You have the following requirements:
• The deployment model must support changing the content of connection strings
by using parameters at execution time.
• The deployment model must automatically log events to the SSISDB database.
• Maximize performance at execution time.
You need to design a solution that meets the requirements. What should you do? (More than one
answer choice may achieve the goal. Select the BEST answer.)

DRAG DROP
You are the administrator for a Data Quality Server. You are adding a user who must have permission to:
 Edit and execute a project
 View the activity monitoring data
This user must not be able to:
 Perform any kind of knowledge management
 Create or change a knowledge base
 Terminate an activity or perform administrative dutiesYou need to develop a Transact-SQL (T-SQL) script to meet these requirements.
What should you do? (To answer, drag the appropriate code segment or segments to the correct
location or locations in the answer area.)

DRAG DROP
A new dedicated server is used to execute resource-intensive SQL Server Integration Services (SSIS) 2012
packages. The environment that you are deploying the packages to has the following constraints:
 The operating system is Windows Server 2008 R2.
 The SSIS packages are stored in the SSIS catalog.
 Some of these SSIS packages use 32-bit custom components.
You need to install only the components that are required to deploy and run the packages on the new
server.
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.)

HOTSPOT
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer
dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract,
Transform and Load (ETL) process execution. You need to use the least amount of development effort to
achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer
area.)

HOTSPOT
A SQL Server Integration Services (SSIS) package is designed to download data from a financial database
hosted in SQL Azure.
The connection string to the financial database is defined as a project parameter named FinConStr. The
parameter value must be stored securely and must be set explicitly every time the package is executed.
You need to configure the parameter to meet the requirements.
What should you do? (To answer, configure the appropriate option or options in the dialog box in the
answer area.)

HOTSPOT
You are the Master Data Services (MDS) administrator at your company.
An existing user must be denied access to a certain hierarchy node for an existing model.
You need to configure the user’s permissions.
Which user management menu item should you select? (To answer, configure the appropriate option or
options in the dialog box in the answer area.)

DRAG DROP
You are loading a dataset into SQL Server. The dataset contains numerous duplicates for the Artist and
Song columns.
The values in the Artist column in the dataset must exactly match the values in the Artist domain in the
knowledge base. The values in the Song column in the dataset can be a close match with the values in
the Song domain.You need to use SQL Server Data Quality Services (DQS) to define a matching policy rule to identify
duplicates.
How should you configure the Rule Editor? (To answer, drag the appropriate answers to the answer
area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. An Execute SQL task in the package
checks product stock levels and sets a package variable named InStock to TRUE or FALSE depending on
the stock level found.
After the successful execution of the Execute SQL task, one of two data flow tasks must run, depending
on the value of the InStock variable.
You need to set the precedence constraints.
Which value for the evaluation operation should you use? (To answer, select the appropriate option for
the evaluation operation in the answer area.)