1.

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?

A. You should use the EncryptPartWithUserKey option.
B. You should use the EncryptSensitiveWithLoginName option.
C. You should use the SaveSensitive option.
D. You should use the EncryptAllWithUserKey option.
Answer» E.


Discussion

No Comment Found