PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform in sequence?

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

PrepAway - Latest Free Exam Questions & Answers

Answer: See the explanation.

Explanation:

Box 1:

Box 2:

Box 3:

Note:
* You are going to become very very familiar indeed with [catalog].[executions]. It is a view
that provides a record of all package executions on the server and, most importantly, it
contains [execution_id] – the identifier for each execution and the field to which all other
objects herein will be related.

4 Comments on “Which three actions should you perform in sequence?


Leave a Reply