Exam 70-767 topic 1 question 33 discussion

HOTSPOT -
You are testing a Microsoft SQL Server Integration Services (SSIS) package. The package includes the Control Flow task shown in the Control Flow exhibit (Click the Exhibit button) and the Data Flow task shown in the Data Flow exhibit. (Click the Exhibit button.)


You declare a variable named Seed as shown in the Variables exhibit. (Click the Exhibit button.) The variable is changed by the Script task during execution.

You need to be able to interrogate the value of the Seed variable after the Script task completes execution.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Hot Area:

Suggested Answer:
✑ The Locals window displays variable that are local to the current statement, as well as three statements behind and in front of the current statement.
✑ To use the Watch window you need to specify which variable you should watch.
✑ MessageBox.Show can be used to display variables.
References:
https://docs.microsoft.com/en-us/sql/integration-services/variables-window