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.
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?
Change the similarity threshold to 0.40.
Decrease the maximum number of matches per lookup.
Change the similarity threshold to 0.85.
Increase the maximum number of matches per lookup.
Correct Answer: C
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?
SQL Server Integration Services Deployment Wizard
SQL Server Configuration Manager
SSIS Upgrade Wizard in SQL Server Management Studio
SSIS Upgrade Wizard in SQL Server 2008 BIDS
Correct Answer: C
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?
Microsoft SharePoint Foundation 2010 SP1
SQL Server 2012 Enterprise (64-bit) x64 on the database server
SQL Server 2012 Data Center (64-bit) x64 on the database server
SQL Server 2008 Enterprise (64-bit) x64 on the database server
Correct Answer: B
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
Install SQL Server 2012 Database Engine.
Install Microsoft SharePoint Server 2010 Enterprise Edition with PowerPivot.
Make sure the server has at least 4 GB of RAM.
Install Microsoft Internet Explorer 6.0 SP1 or later.
Correct Answer: A
You are implementing a SQL Server Integration Services (SSIS) package that imports Microsoft
Excel workbook data into a Windows Azure SQL 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?
Install a 64-bit ACE driver and execute the package by using the 64-bit run-time option.
Enable Address Windowing Extensions (AWE) for the local SQL Server instance.
Replace the SSIS Excel source with a SSIS Flat File source.
Install a 64-bit ACE driver and replace the Excel source with an OLE DB source.
Correct Answer: D
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
To answer, move the appropriate actions from the list of actions to the answer area and arrange
them in the correct order.
Select and Place:
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
To answer, select the appropriate profile type in the answer area.
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.
Instant Access to Download Latest Complete Collection of Microsoft MCSE 70-463 Real Exam
Try Microsoft MCSE 70-463 Free Demo