PrepAway - Latest Free Exam Questions & Answers

What should you do?

You are a database administrator for AIOTestKing.com. You create a SQL Server Integration Services (SSIS) package that contains confidential information. The package will be used by only two company employees. The package is stored in the msdb database. You need to ensure that only the appropriate employees can execute the package. You must accomplish this goal by using the least amount of administrative effort. What should you do?

PrepAway - Latest Free Exam Questions & Answers

A.
Configure the package to use the Encrypt all with user key package protection level.

B.
Configure the package to use the Encrypt all with password package protection level.

C.
Save the package to a file. Encrypt the file by using the Encrypting File System (EFS).

D.
Save the package to a SQL Server 2005 computer that has an IPSec Secure Server policy applied.

Explanation:
Encrypt all with password – Encrypts the whole package by using a password. The package is encrypted by using a password that the user supplies when the package is created or exported. To open the package in SSIS Designer or run the package by using the dtexec command prompt utility, the user must provide the package password. Without the password the user cannot access or run the package.


Leave a Reply