MCQOPTIONS
Saved Bookmarks
| 1. |
You work as a database administrator at Abc.com. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package for Abc.com. You make use of local development environment in order to check the package. You then publish the package to the file system on a production server named ABC-DB02. However, Abc.com users inform you that they are unable to access the package. You need to ensure that Abc.com users are able to access and run the package. What should you do? |
| A. | You should use the SaveSensitive option. |
| B. | You should use the ServerStorage option. |
| C. | You should use the EncryptAllWithPassword option. |
| D. | You should use the EncryptPartWithUserKey option.5)You should use the EncryptSensitiveWithLoginName option. |
| Answer» D. You should use the EncryptPartWithUserKey option.5)You should use the EncryptSensitiveWithLoginName option. | |