Câu 42: 70-463: MCSA Implementing a Data Warehouse with Microsoft SQL Server 20122014

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 variablesExecute 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.)

1. A. In the SSISDB database, add QA Tester logons to the ssis_admin role.
2. B. In the msdb database, add QA Tester logons to the db_ssisoperator role.
3. C. Grant Modify permission in the projects to the QA Tester logons.
4. D. Grant Read permission in the SSIS catalog folder, the projects, and the Environments to the QA Tester logons. — đáp án hiện tại
5. E. Grant Execute permission in the projects to the QA Tester logons. — đáp án hiện tại
6. F. In the msdb database, add QA Tester logons to the db_ssisItduser role.