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?

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?

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 user-defined 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 commaseparated 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.)

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.
Which item should you use?