nerdexam
Microsoft

70-448 · Question #14

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. You deploy the package to the file system in the…

The correct answer is C. EncryptAllWithPassword. See the full explanation below for the reasoning.

Question

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. You deploy the package to the file system in the production environment. The users report that the connection strings contained in the package are blank. The package fails to execute. You need to change the protection level of the package to ensure that users can view and execute the package. Which protection level should you use?

Options

  • ADontSaveSensitive
  • BEncryptAllWithUserKey
  • CEncryptAllWithPassword
  • DServerStorage

How the community answered

(30 responses)
  • A
    7% (2)
  • B
    17% (5)
  • C
    73% (22)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice