YOU NEED TO DEPLOY AN SSIS PACKAGE TO A PRODUCTION SERVER. YOU WAN...

14. You need to deploy an SSIS package to a production server. You want to use

package roles to control access to the packages. When the developer creates

the package, which protection level should they use?

A. Encrypt sensitive with password

B. Encrypt all with user key

C. Rely on server storage and roles for access control

D. Encrypt all with password