get the app

Question: 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.

Previous Next

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

Exam 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