Administering Microsoft SQL Server 2012/2014 Databases — Question 4

You administer a Microsoft SQL Server database instance. You create a new user named UserA.
You need to ensure that UserA is able to create SQL Server Agent jobs and execute SQL Server Agent jobs owned by UserA
To which role should you add UserA?

Answer options

• A. RSExecRole
• B. SQLAgentUserRole
• C. serveradmin
• D. DatabaseMailUserRole B

Correct answer:

Explanation

UserA needs to be part of the SQLAgentUserRole to create and execute SQL Server Agent jobs that they own. The other options, such as RSExecRole and DatabaseMailUserRole, do not provide the necessary permissions for managing SQL Server Agent jobs, while serveradmin grants broader server-level permissions not specifically focused on job management.