DRAG DROP
You plan to deploy a SQL Server Integration Services (SSIS) project by using the project deployment
model.
You need to monitor control flow tasks to determine whether any of them are running longer than
usual. 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.)

DRAG DROP
You are designing a SQL Server Integration Services (SSIS) package to execute 12 Transact-SQL (T-SQL)
statements on a SQL Azure database. The T-SQL statements may be executed in any order. The T-SQL
statements have unpredictable execution times.
You have the following requirements:
• The package must maximize parallel processing of the T-SQL statements.
• After all the T-SQL statements have completed, a Send Mail task must notify
administrators.
You need to design the SSIS package. 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.)

DRAG DROP
You are creating a SQL Server Integration Services (SSIS) package to populate a fact table from a source
table. The fact table and source table are located in a SQL Azure database. The source table has a price
field and a tax field. The OLE DB source uses the data access mode of Table.
You have the following requirements:
• The fact table must populate a column named TotalCost that computes the sum of
the price and tax columns.
• Before the sum is calculated, any records that have a price of zero must be
discarded.
You need to create the SSIS package in SQL Server Data Tools.In what sequence should you order four of the listed components for the data flow task? (To answer,
move the appropriate components from the list of components to the answer area and arrange them in
the correct order.)

You are designing an extract, transform, load (ETL) process for loading data from a SQL Server database
into a large fact table in a data warehouse each day with the prior day’s sales data.
The ETL process for the fact table must meet the following requirements:
 Load new data in the shortest possible time.
 Remove data that is more than 36 months old.
 Ensure that data loads correctly.
 Minimize record locking.
 Minimize impact on the transaction log.
You need to design an ETL process that meets the requirements. What should you do? (More than one
answer choice may achieve the goal. Select the BEST answer.)

You are designing a fact table in a SQL Server database.
The fact table must meet the following requirements:
• Include a columnstore index.
• Allow users to choose up to 10 dimension tables and up to five facts at one time.
• Maximize performance of queries that aggregate measures by using any of the 10
dimensions.
• Support billions of rows.
• Use the most efficient design strategy.
You need to design the fact table to meet the requirements. What should you do? (More than one
answer choice may achieve the goal. Select the BEST answer.)

DRAG DROP
You are validating whether a SQL Server Integration Services (SSIS) package named Master.dtsx in the
SSIS catalog is executing correctly.
You need to display the number of rows in each buffer passed between each data flow component of
the package.
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 designing a SQL Server Integration Services (SSIS) package configuration strategy.
The package configuration must meet the following requirements:
 Include multiple properties in a configuration.
 Force packages to load all settings in the configuration.
 Support Encrypting File System (EFS) formats.
You need to select the appropriate configuration.
Which configuration type should you use?
To answer, select the appropriate option from the drop-down list in the dialog box.

You are designing a SQL Server Integration Services (SSIS) solution that will load multiple Online
Transactional Processing (OLTP) data sources into a SQL Server data mart.
You have the following requirements:
• Ensure that the process supports the creation of an exception report that details
possible duplicate key values, null ratios within columns, and column-length
distributions of values.
• Ensure that users can generate the exception report in an XML format.
• Use the minimum development effort.
You need to design the SSIS solution to meet the requirements. What should you do? (More than one
answer choice may achieve the goal. Select the BEST answer.)

You are designing a SQL Server Integration Services (SSIS) solution. The solution will contain an SSIS
project that includes several SSIS packages. Each SSIS package will define the same connection managers
and variables.
You have the following requirements:
• The deployment model must support changing the content of connection strings
by using parameters at execution time.
• The deployment model must automatically log events to the SSISDB database.
• Maximize performance at execution time.
You need to design a solution that meets the requirements. What should you do? (More than one
answer choice may achieve the goal. Select the BEST answer.)

HOTSPOT
You are developing a SQL Server Integration Service (SSIS) package. The package loads a customer
dimension table by using a data flow task.
Changes to the customer attributes must be tracked over time.
You need to produce a checksum value to identify the rows that have changed since the last Extract,
Transform and Load (ETL) process execution. You need to use the least amount of development effort to
achieve this goal.
Which transformation should you use? (To answer, select the appropriate transformation in the answer
area.)