You work as a database administrator at The network contains a production database server named ABC-DB01. You have recently created a SQL Server 2008 Integration Services (SSIS) instance that you tested in a local development environment. You deploy the SSIS instance to ABC- DB01. You need to ensure that the protection level for users is configured when they run the package. What should you do?

1)You should use the EncryptPartWithUserKey option.

2)You should use the EncryptSensitiveWithLoginName option.

3)You should use the SaveSensitive option.

4)You should use the EncryptAllWithUserKey option.

  • : 370
  • : 16
    Previous Next

    You should use the EncryptAllWithUserKey option.

    Suggest other answer
    Login to Discuss/suggest the answer...

  • Exam: 70-448 MS SQL Server 2008, Business Intelligence

    Recommended Learning for you

    Subscribe here for free mock test on IAS PCS SSC and other competitive exam. Signup here to get SSC CGL Solution and main exam study material