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.)

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?

You are designing a SQL Server Integration Services (SSIS) 2012 package that imports data from a
Windows Azure SQL Database database into a SQL Server database.
The SSIS package has the following requirements:
 Every night, a very large amount of data is imported into the staging database.
 Package processing time must be minimized.
 The package must run on its own dedicated server when it is deployed to production.
 Transaction log activity when data is imported must be minimized.
You need to design the package to meet the requirements.
Which destination component should you use?

You are implementing a SQL Server Integration Services (SSIS) 2012 package that loads data from
various flat files and a Windows Azure SQL Database database.
Daily transactions must be loaded into a staging database. All the SSIS tasks will use the CurrentDate
variable as the transaction date.You need to set the CurrentDate variable to the date stored in a control table of the Windows Azure SQL
Database database when the package starts. You need to achieve this goal by using the least amount of
development effort.
What should you use to set the variable?

You are preparing to install SQL Server 2012 Master Data Services (MDS).
You need to ensure that the database requirements are met.
What should you install?