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:
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.
catalog.Executables is not even offered as an answer.
Almost identical question is 15.
Still, not sure why this two questions differ.
Should be catalog.Executions View
Same as question 19
question 19 is different. executable view is for control flow
exactly same question, answer correct
ok
ok
Which answer is right?
catalog.executions view is right…
catalog.executables view doesn’t contain the required information