You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services (SSIS) catalog. You need to ensure that the package credentials are…

The correct answer is D. EncryptSensitivewithUserKey. The SSISDB catalog uses the ServerStorage protection level. When you deploy an Integration Services project to the Integration Services server, the catalog automatically encrypts the package data and sensitive values. The catalog also automatically decrypts the data when you If…

Configure and deploy SSIS solutions

Question

You plan to deploy a package to a server that has SQL Server installed. The server contains a SQL Server Integration Services (SSIS) catalog. You need to ensure that the package credentials are encrypted. Which protection level should you set for the package?

Options

AServerStorage
BEncryptAllWithUserKey
CEncryptSensitivewithPassword
DEncryptSensitivewithUserKey

How the community answered

(22 responses)

C
5% (1)
D
95% (21)

Explanation

The SSISDB catalog uses the ServerStorage protection level. When you deploy an Integration Services project to the Integration Services server, the catalog automatically encrypts the package data and sensitive values. The catalog also automatically decrypts the data when you If you export the project (.ispac file) from the Integration Services server to the file system, the system automatically changes the protection level to EncryptSensitiveWithUserKey. sensitive- data-in-packages?view=sql-server-2017

Topics

#package protection level#SSIS encryption#SSIS catalog#sensitive data

Community Discussion

No community discussion yet for this question.

Full 70-463 Practice