YOU ARE A SYSADMIN ON YOUR SQL SERVER INSTANCE. YOU ARE TRYING TO...

17. You are a sysadmin on your SQL Server instance. You are trying to manage the

package roles on the “Export Product Data” package shown in Figure 8.8, but

receive an error. What must you do to allow the package roles to be used?

Figure 8.8 Exporting Product Data

A. Use the “Encrypt all with user key” protection level

B. Use the “Encrypt all with password” protection level

C. Save the package to the MSDB database rather than the file system.

D. Add your user to the db_ssisadmin database role