You are using the Knowledge Discovery feature of the Data Quality Services (DQS) client
application to modify an existing knowledge base.
In the mapping configuration, two of the three columns are mapped to existing domains in
the knowledge base. The third column, named Group, does not yet have a domain.
You need to complete the mapping of the Group column.
What should you do?

You are installing SQL Server Data Quality Services (DQS).
You need to give specific users access to the Data Quality Server.
Which SQL Server application should you use?

You manage a SQL Server Master Data Services (MDS) environment.
A new application requires access to the product data that is available in the MDS
repository.
You need to design a solution that gives the application access to the product data with the
least amount of development effort.
What should you do?

You are completing the installation of the Data Quality Server component of SQL Server
Data Quality Services (DQS).
You need to complete the post-installation configuration.
What should you do?

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package uses custom functionality that accesses a 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.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) project by using the Project
Deployment model.
The project contains many packages. It is deployed on a server named SQLTest1. The
project will be deployed to several servers that run SQL Server 2012.
The project accepts one required parameter. The data type of the parameter is a string.
A SQL Agent job is created that will call the Loading.dtsx package in the project. A job step
is created for the SSIS package.
The job must pass the value of an SSIS Environment Variable to the project parameter. The
value of the Environment Variable must be configured differently on each server that runs
SQL Server. The value of the Environment Variable must provide the server name to the
project parameter.
You need to configure SSIS on the SQLTest1 server to pass the Environment Variable to the
package.
Which four actions should you perform in sequence by using SQL Server Management
Studio?
(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 three Execute SQL tasks modify products in
staging tables in preparation for a data warehouse load.
The package and all three Execute SQL product tasks have their TransactionOption property
set to Supported.
You need to ensure that if any of the three Execute SQL product tasks fail, all three tasks will
roll back their changes.
What should you do?

You are creating a SQL Server Integration Services (SSIS) package that implements a Type
3 Slowly Changing Dimension (SCD).
You need to add a task or component to the package that allows you to implement the SCD
logic.
What should you use?

You are developing a SQL Server Integration Services (SSIS) package to load data into a
SQL Server table on ServerA, 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 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?