You are the administrator of a server that hosts Data Quality Server for a large retail company.
The server had a hardware failure during business hours.
You need to restore the server that hosts Data Quality Server to another server. You have a recent
backup of all the required databases.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)

You are designing an extract, transform, and load (ETL) solution that loads data into dimension tables.
The ETL process involves many transformation steps.
You need to ensure that the design can provide:
 Auditing information for compliance and business user acceptance
 Tracking and unique identification of records for troubleshooting and
error correction
What should you do?

To support the implementation of new reports, Active Directory data will be downloaded to a SQL
Server database by using a SQL Server Integration Services (SSIS) 2012 package.
The following requirements must be met:
All the user information for a given Active Directory group must be downloaded to a SQL Server table.
The download process must traverse the Active Directory hierarchy recursively.You need to configure the package to meet the requirements by using the least development effort.
What should you use?

HOTSPOT
You are a data warehouse developer responsible for developing data cleansing processes.
Duplicate employees exist in an employee dimension.
You need to map, discover, and manage domain values based on the employee dimension.
Which Data Quality Services (DQS) option should you use? (To answer, select the appropriate option in
the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The package contains a userdefined variable named @Queue which has an initial value of 10.
The package control flow contains many tasks that must repeat execution until the @Queue variable
equals 0.
You need to enable the tasks to be grouped together for repeat execution.
Which item should you add to the package? (To answer, select the appropriate item in the answer area.)

You are creating a Data Quality Services (DQS) solution. You must provide statistics on the accuracy of
the data.
You need to use DQS profiling to obtain the required statistics.
Which DQS activity should you use?

You are developing a SQL Server Integration Services (SSIS) project to read and write data from a
Windows Azure SQL Database database to a server that runs SQL Server 2012.
The connection will be used by data flow tasks in multiple SSIS packages. The address of the target
Windows Azure SQL Database database will be provided by a project parameter.
You need to create a solution to meet the requirements by using the least amount of administrative
effort.
What should you do?

A SQL Server Integration Services (SSIS) 2012 package currently downloads sales data from a Windows
Azure SQL Database database.
To improve sales data accuracy, exchange rates must be downloaded daily from a public HTTP website
instead of from a weekly flat file. The public website hosts a comma-separated values (CSV) file that
contains one row per currency.
You need to download the CSV file to the environment.
What should you use to retrieve the document from the website?

You are designing a SQL Server Integration Services (SSIS) data flow to load sales transactions from a
source system into a data warehouse hosted on Windows Azure SQL Database. 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 administering SQL Server Integration Services (SSIS) permissions on a production server that
runs SQL Server 2012.
Package developers in your company must have permission to perform the following tasks only on their
own projects:
View projects and packages, View Environments, Validate packages, Execute packages.
You need to grant rights to the developers without assigning unnecessary privileges.
What should you do? (Each correct answer presents part of a solution. Choose all that apply.)