nerdexam
Microsoft

70-448 · Question #69

You are creating a SQL Server 2008 Integration Services (SSIS) instance which is deployed to a production server for Company.com. You should utilize local development environment to check it. You…

The correct answer is D. You should utilize EncryptAllWithUserKey. See the full explanation below for the reasoning.

Question

You are creating a SQL Server 2008 Integration Services (SSIS) instance which is deployed to a production server for Company.com. You should utilize local development environment to check it. You should make sure that you should set the protection level for users when the user decides to run it. Which is the correct answer?

Options

  • AYou should utilize EncryptPartWithPassword
  • BYou should utilize EncryptSensitiveWithLoginName
  • CYou should utilize SaveSensitive
  • DYou should utilize EncryptAllWithUserKey

How the community answered

(23 responses)
  • A
    4% (1)
  • B
    9% (2)
  • C
    17% (4)
  • D
    70% (16)

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice