Microsoft
70-463 · Question #221
70-463 Question #221: Real Exam Question with Answer & Explanation
Sign in or unlock 70-463 to reveal the answer and full explanation for question #221. The question stem and answer options stay visible for context.
Configure and deploy SSIS solutions
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
- EGrant Execute permission in the projects to the QA Tester logons.
- FIn the msdb database, add QA Tester logons to the db_ssisItduser role.
Unlock 70-463 to see the answer
You've previewed enough free 70-463 questions. Unlock 70-463 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SSIS security#catalog permissions#role-based access#minimum privileges