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
opened 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 command should you use? (To answer, select the appropriate command 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 maintain a SQL Server Integration Services (SSIS) package. The package was
developed by using SQL Server 2008 Business Intelligence Development Studio (BIDS).
The package includes custom scripts that must be upgraded.
You need to upgrade the package to SQL Server 2012.
Which tool should you use?

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?

DRAG DROP
Your company is evaluating the data cleansing capabilities of SQL Server Data Quality
Services (DQS).
A stand-alone server will be used to host DQS, as well as all related services necessary to
run this service.
You need to install the DQS components on the server by using the minimum amount of
steps possible. You also need to grant permissions to a login named DataStewards to
enable DataStewards to edit and execute DQS projects.
Which four 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.
You use a Data Profiling task to examine the data from a source system. You need to
establish:
The minimum and maximum dates for the datetime columns in the source data
The minimum, maximum, and average values for numeric columns in the source data
You need to use the appropriate profile type in the Data Profiling task.
Which profile type should you use? (To answer, select the appropriate profile type in the
answer area.)

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 data source will be polled once per hour. The data is updated with multiple important
status changes per minute.
For each captured data change, the before and after values must be included.
You need to configure the CDC Source component.
Which CDC processing mode should you select? (To answer, configure the appropriate
option in the dialog box in the answer area.)

HOTSPOT
You are developing a SQL Server Integration Services (SSIS) package.
OnError and OnWarning events must be logged for viewing in the built-in SSIS reports by
using SQL Server Management Studio.
You need to execute the package and minimize the number of event types that are logged.
Which setting should you use? (To answer, change the appropriate setting in the answer
area.)