What should you do?

Posted by: Pdfprep Category: 70-467 Tags: , ,

You need to grant appropriate permissions to the SSISOwners SQL Server login.

What should you do?
A . Map the login to the SSISDB database. Assign the user to the ssis_admin role.
B . Map the login to the msdb database. Assign the user to the db_owner role.
C . Map the login to the msdb database. Assign the user to the db_ssisadmin role.
D . Map the login to the SSISDB database. Assign the user to the db_ssisadmin role.
E . Map the login to the SSISDB database. Assign the user to the db_owner role.
F . Map the login to the msdb database. Assign the user to the ssis_admin role.

Answer: D

Leave a Reply

Your email address will not be published.