Microsoft
70-457 · Question #186
70-457 Question #186: Real Exam Question with Answer & Explanation
The correct answer is B. In the msdb database, add QA Tester logons to the db_ssisoperator role. D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA. See the full explanation below for the reasoning.
Question
You are administering SQL Server Integration Services (SSIS) permissions on a production server that runs SQL Server 2012. Quality Assurance (QA) testers in the company must have permission to perform the following tasks on specific projects: - View and validate projects and packages - View Environments and Environment variables - Execute packages You need to grant the minimum possible privileges to the QA testers. What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
Options
- AIn the SSISDB database, add QA Tester logons to the ssis_admin role.
- BIn the msdb database, add QA Tester logons to the db_ssisoperator role.
- CGrant Modify permission in the projects to the QA Tester logons.
- DGrant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA
- EGrant Execute permission in the projects to the QA Tester logons.
- FIn the msdb database, add QA Tester logons to the db_ssisItduser role.
Community Discussion
No community discussion yet for this question.