Exam 70-463 topic 3 question 52 discussion

Actual exam question from Microsoft's 70-463

Question #: 52
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: DE 🗳️
Incorrect Answers:
B: "perform the following tasks on specific projects:" All the required tasks are performed within specific projects. In other words, not individual packages stored in the MSDB database.
References:
https://www.mssqltips.com/sqlservertip/3153/managing-ssis-security-with-database-roles/ https://anothersqlgeek.wordpress.com/2013/07/20/sql-2012-ssis-catalog-permissions/

by designsfactory at April 4, 2025, noon

Comments

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam

Exam 70-463 topic 3 question 52 discussion

Comments

SY0-701