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.)
A.
In the SSISDB database, add QA Tester logons to the ssis_admin role.
B.
In the msdb database, add QA Tester logons to the db_ssisoperator role.
C.
Grant Modify permission in the projects to the QA Tester logons.
D.
Grant Read permission in the SSIS catalog folder, the projects, and the Environments to
the QA Tester logons.
E.
Grant Execute permission in the projects to the QA Tester logons.
F.
In the msdb database, add QA Tester logons to the db_ssisItduser role.
D, E
not A, B, F because this are only for msdb database (https://msdn.microsoft.com/en-us/library/ms141053.aspx) where can not be projects and Environments and Environment variables. So we can use only security model of SSISDB catalogs: definly D and E. C is to extra righs
0
0
D and E
0
0
Agreed with previous comments the correct answer is D and E.
checkout this link;
https://msdn.microsoft.com/en-us/library/hh479588(v=sql.110).aspx
0
0
no answer on this link
0
0
DE
0
0
Why not BDE. Without B, you won’t have access to any of the packages hiding in the msdb and you have to be able to validate and execute packages and projects.
0
0
yes, why you excluding B?
0
0
so which are correct?
0
0