get the app get the app       get the app       get the app
You work as a database administrator at Abc.com. The Abc.com 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.


  • : 193
  • : 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

    Close(X)
    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