You develop a SQL Server Integration Services (SSIS) project by using the Package Deployment Model. A
package in the project extracts data from a Windows Azure SQL Database database.
The package is deployed to SQL Server.
The package is not producing the desired results.
You need to generate the .mdmp and .tmp debug files in order to troubleshoot the issues.
What should you do?

You are developing a SQL Server Integration Services (SSIS) project that contains a project Connection
Manager and multiple packages.
All packages in the project must connect to the same database. The server name for the database must
be set by using a parameter named ParamConnection when any package in the project is executed.
You need to develop this project with the least amount of development effort.
What should you do? (Each answer presents a part of the solution. Choose all that apply.)

You are deploying a new SQL Server Integration Services (SSIS) package to five servers.
The package must meet the following requirements:
• .NET Common Language Runtime (CLR) integration in SQL Server must not be
enabled.
• The Connection Managers used in the package must be configurable without
editing and redeploying the package.
• The deployment procedure must be automated as much as possible.
• Performance must be maximized.
You need to set up a deployment strategy that meets the requirements.
What should you do?

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 the data steward at your company.Duplicate customers exist in a Microsoft Excel workbook. You create a Data Quality Services (DQS)
knowledge base and matching policy to identify these duplicate customers.
You need to identify the duplicate customers.
Which option should you use? (To answer, select the appropriate option 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 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.)

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

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