Which three actions should you perform in sequence?

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

Answer: See the explanation

Explanation:
Box 1:

Box 2:

Box 3:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


vakum

vakum

The answer should be execution_component_phases and EXECUTABLES

catalog.executables – execution per task
catalog.executions – execution per package
catalog.execution_component_phases – execution per component