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

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

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.



Leave a Reply 9

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


HR_OS_B

HR_OS_B

catalog.Executables is not even offered as an answer.

Almost identical question is 15.

Still, not sure why this two questions differ.

Manoj

Manoj

Should be catalog.Executions View

HR_OS_B

HR_OS_B

Same as question 19

Kay

Kay

question 19 is different. executable view is for control flow

d

d

exactly same question, answer correct

Mahmoud Ibrahim

Mahmoud Ibrahim

ok

Mahmoud Ibrahim

Mahmoud Ibrahim

ok

MCSE-467

MCSE-467

Which answer is right?

CS

CS

catalog.executions view is right…

catalog.executables view doesn’t contain the required information