get the app get the app       get the app       get the app


Question: 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?
1)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.
2)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.
3)You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptAllWithPassword on the SSIS package.
4)You should make use of the SSIS package designer in order to set the PackageProtectionLevel property to EncryptSensitiveWithUserKey on the SSIS package.


Previous Next
Exam


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

Exam Exam: 70-448 MS SQL Server 2008, Business Intelligence





Recommended Learning for you

Close(X)
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