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: Correct
Explanation:
1. Add Sequence Container
2. Add SQL tasks to Sequence container
3. Add mail task with precedence to Sequence container
#3: Add a Send Mail task to the Control Flow, and a precedence constraint of COMPLETION to the Sequence container
Why do you need sequence container? You have to implement parallel process. The sequence container will execute tasks one after another. I think 5-4-1 is the correct answer
Ups, my mistake. You are right.
I think then point 2 must be “Query against execution_component_phases and executables.” . “An executable is a task or container that you add to the control flow of a package.” – https://msdn.microsoft.com/en-us/library/hh479595.aspx.
Executions is on whole package level, not different tasks in control flow.
2
6
1