MCQOPTIONS
Saved Bookmarks
| 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. | |