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 developing a SQL Server Integration Services (SSIS) package.
The package sources data from an HTML web page that lists product stock levels.
You need to implement a data flow task that reads the product stock levels from the HTML
web page.
Which data flow source should you use?

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