nerdexam
Microsoft

70-448 · Question #13

You develop a package by using SQL Server 2008 Integration Services (SSIS). You test the package by using your local development environment. The package is deployed to a production server. You need…

The correct answer is D. EncryptAllWithUserKey. 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. The package is deployed to a production server. You need to configure the protection level of the package to ensure that only the user who deployed the package can execute it. Which protection level should you use?

Options

  • AEncryptAllWithPassword
  • BEncryptSensitiveWithPassword
  • CDontSaveSensitive
  • DEncryptAllWithUserKey

How the community answered

(14 responses)
  • A
    14% (2)
  • B
    7% (1)
  • D
    79% (11)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice