MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
| 1. |
You work as a database administrator at Abc.com. The Abc.com network contains a production database server named ABC-DB01. You are in the process of creating a SQL Server 2008 Integration Services (SSIS) package. The SSIS package is stored in a folder on ABC-DB01. All Abc.com users must be able to view the package but must not be able to view the attribute values. You need to ensure that the attribute values are protected by password. What should you do? |
| A. | You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to EncryptSensitiveWithPassword on the SSIS package. |
| B. | You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to SaveSensitive on the SSIS package. |
| C. | You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptAllWithPassword on the SSIS package. |
| D. | You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptSensitiveWithUserKey on the SSIS package. |
| Answer» B. You should make use of a batch file that runs the dtutil program in order to set the PackageProtectionLevel property to SaveSensitive on the SSIS package. | |