DRAG DROP
You are maintaining a SQL Server Integration Services (SSIS) package. The package uses custom
functionality that is implemented in Microsoft Visual C#.
The implementation of the custom functionality changes overtime. The design of the package allows you
to deploy new releases of the custom functionality without redeploying the entire package.You need to implement and deploy an update to the custom functionality without requiring package
redeployment.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package. The data source for the data flow
task is a table that has been configured as a change data capture (CDC) table. You are using a CDC
Source component to obtain the CDC data.The CDC Source component has the following requirements:
 The output must include metadata columns that indicate which source columns have changed.
 The output must return only one change row per source row that is modified in the current CDC
processing range.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate option or options
in the dialog box in the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
The package must run a parameterized query against a Windows Azure SQL Database database.
You need to use the least amount of development effort to meet the package requirement.
Which task should you use? (To answer, select the appropriate task in the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package to implement an incremental data
load strategy. The package reads rows from a source system and compares them to rows in a
destination system. New rows will be inserted and changed rows will be updated.
You have used a Lookup transformation and a Conditional Split transformation. The Lookup
transformation joins the source and destination table on the business key, and includes all columns from
the destination table in the data flow output. The Conditional Split transformation inspects the
destination columns and directs data flow to either insert new records or update existing records.
You need to configure the Lookup transformation to ensure that all records flow to the Conditional Split
transformation, regardless of whether the rows match an existing row in the destination table.
Which setting should you select? (To answer, select the appropriate option in the answer area.)

DRAG DROP
You are developing a SQL Server Integration Services (SSIS) package.
The package contains an ADO object source variable that holds a result set that was returned by a
stored procedure execution.
You need to add and configure a container that will execute several tasks for each row in the ADO object
source variable.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from
the list of actions to the answer area and arrange them in the correct order,)

HOTSPOT
You are using the Master Data Services (MDS) Add-in for Excel to configure the entities in a model. The
model consists of two entities: one named Customer and one named State. You open the Customer
entity.
Currently, data stewards can enter any text value in the Customer entity’s State attribute. You must
restrict the entry of values in the State attribute to members defined in the State entity.
You need to configure the State attribute of the Customer entity.
Which option should you use? (To answer, select the appropriate area in the answer area.)

You develop a SQL Server Integration Services (SSIS) package that imports Windows Azure SQL Database
data into a data warehouse every night.
The Windows Azure SQL Database data contains many misspellings and variations of abbreviations. To
import the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching
string from a reference table of allowed values. The number of rows in the reference table is very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without
degrading performance.
What should you do?

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 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?

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?