nerdexam
Microsoft

70-448 · Question #151

You are a database developer and you have about two years experience in creating business intelligence (BI) solutions by using SQL Server 2008. Now you are employed in a company which is named…

The correct answer is A. EncryptAllWithPassword level would be used. 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) solutions by using SQL Server 2008. Now you are employed in a company which is named NaproStar and work as a developer of a SQL Server 2008 Integration Services (SSIS) for the company. To meet the business requirement, you use the SSIS to develop a package and use your local development environment to test the package. Then the package is deployed to the file system in the production environment. After the deployment, the users notice that the package contains no connection strings, which means the package gets a failure of the deployment. Now you are assigned a task to make sure that the package can be viewed and executed by changing the protection level of the package. So of the protection levels of the package, which one would be used?

Options

  • AEncryptAllWithPassword level would be used
  • BServerStorage level would be used
  • CServerChange level would be used
  • DDontSaveSensitive level would be used
  • EEncryptAllWithUserKey level would be used

How the community answered

(24 responses)
  • A
    71% (17)
  • B
    8% (2)
  • C
    4% (1)
  • E
    17% (4)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice