70-463 · Question #182
70-463 Question #182: Real Exam Question with Answer & Explanation
The correct answer is B: Add developer logins to the db_ssisoperator role in the msdb database.. B: db_ssisoperator Enumerate all packages. View all packages. Execute all packages. Export all packages. Execute all packages in SQL Server Agent. D: Need read permissions on the Environments in order to be able to view them. Not A: db_ssisltduser Enumerate own packages. Enumerat
Question
Options
- AAdd developer logins to the db_ssisltduser role in the msdb database.
- BAdd developer logins to the db_ssisoperator role in the msdb database.
- CGrant Execute permission in the projects for the developer logins.
- DGrant Read permission in the SSIS catalog folder, the projects, and the Environments.
- EAdd developer logins to the ssis_admin role in the SSISDB database.
- FGrant Modify permission in the projects for the developer logins.
Explanation
B: db_ssisoperator Enumerate all packages. View all packages. Execute all packages. Export all packages. Execute all packages in SQL Server Agent. D: Need read permissions on the Environments in order to be able to view them. Not A: db_ssisltduser Enumerate own packages. Enumerate all packages. View own packages. Execute own packages. Export own packages. Import packages. Delete own packages. Change own package roles. Not E: db_ssisadmin Too many permissions (such as delete all packages).
Community Discussion
No community discussion yet for this question.