You have a secured database that contains all of the customer data for your company. You plan to use
a project deployment model.
You need to create a SQL Server Integration Services (SSIS) package that connects to the database by
using a dedicated username and password. The solution must ensure that the password used for the
connection string is encrypted.
Which two actions should you perform? (Select Two)
A.
Select the Sensitive check box for the catalog environment.
B.
Set the sensitive property of the package parameter to True.
C.
Modify the set_execution parameter_value stored procedure.
D.
Set the package protection level to EncrypSensitiveWithPassword.
System procedures should not be changed so I believe that correct answer is B,D
https://www.intertech.com/Blog/watch-your-ssis-package-encryption-settings/
0
0
Similar to this one:
http://www.aiotestking.com/microsoft/you-need-to-ensure-that-the-username-and-password-values-are-encrypted-when-they-are-deployed-5/
I vote for B,D
0
0
I vote for B,D too.
The diffrence from a question linked by John is that here are package parameters used, and in linked question project parameters are used.
0
0
B, D is correct
0
0
Yes. B,D
0
0