70-448 · Question #56
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL…
The correct answer is C. At the Sequence Container scope the variable should be created. See the full explanation below for the reasoning.
Question
You are a database developer and you have about two years experience in creating business Intelligence (BI) by using SQL Server 2008. Now you are employed in a company named NaproStar which uses SQL Server 2008. You work as the technical support. According to the requirement of the company CIO, you use SQL Server 2008 Integration Services (SSIS) to create a package. The exhibit below shows the structure of the package. You have to define a variable. The variable contains sensitive information that can only be accessed by the Sequence Container, the Data Flow Task, and the Execute SQL Task. What action should you perform?
Options
- AAt the Data Flow Task scope, the variable should be created
- BAt the package scope, the variable should be created
- CAt the Sequence Container scope the variable should be created
- DAt the Execute SQL Task scope, the variable should be created
How the community answered
(59 responses)- A8% (5)
- B10% (6)
- C78% (46)
- D3% (2)
Community Discussion
No community discussion yet for this question.