Microsoft
70-463 · Question #244
70-463 Question #244: Real Exam Question with Answer & Explanation
The correct answer is C: Modify the set_execution parameter_value stored procedure.. Setting the package protection level to EncryptSensitiveWithPassword encrypts the password inside the package, and catalog.set_execution_parameter_value supplies the credential securely at runtime in the project deployment model.
Question
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)
Options
- ASelect the Sensitive check box for the catalog environment.
- BSet the sensitive property of the package parameter to True.
- CModify the set_execution parameter_value stored procedure.
- DSet the package protection level to EncrypSensitiveWithPassword.
Explanation
Setting the package protection level to EncryptSensitiveWithPassword encrypts the password inside the package, and catalog.set_execution_parameter_value supplies the credential securely at runtime in the project deployment model.
Common mistakes.
- A. Marking a catalog environment variable as sensitive causes it to be encrypted within the SSISDB catalog, but this does not encrypt the password stored inside the package file itself.
- B. Setting a package parameter's sensitive property to True flags it for encrypted storage in the SSISDB catalog, but without also setting the package protection level the password remains unencrypted within the package definition.
Concept tested. SSIS package protection level and sensitive parameter encryption
Community Discussion
No community discussion yet for this question.