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?

You are implementing a SQL Server Integration Services (SSIS) package that imports
Microsoft Excel workbook data into a Windows Azure SQL Database database. The
package has been deployed to a production server that runs Windows Server 2008 R2 and
SQL Server 2012.
The package fails when executed on the production server.
You need to ensure that the package can load the Excel workbook data without errors. You
need to use the least amount of administrative effort to achieve this goal.
What should you do?

You are installing the Data Quality Server component of Data Quality Services.
You need to provision the hardware and install the software for the server that runs the Data
Quality Server.
You must ensure that the minimum Data Quality Server prerequisites are met.
What should you do?

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
The package control flow will contain many tasks. The tasks will execute consecutively and
none will execute more than once. Certain groups of tasks will share variable and
transaction scope.
You need to group tasks together while enabling them to be collapsed and expanded as a
group.
Which item should you use from the SSIS Toolbox? (To answer, select the appropriate item
in the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to load data into a
SQL Server 2012 database.
The name of the target instance is passed to the package via an Environment variable.
The Environment variable provides the server name to the Project parameter named
ServerName.
The OLE DB Project Connection Manager has been parameterized.
You need to configure the Connection Manager property to accept the parameter.
Which property and parameter should you use? (To answer, configure the appropriate option
or options in the dialog box in the answer area.)