Administering a SQL Database Infrastructure — Question 85

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

Answer options

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

Correct answer: C

Explanation

The correct answer is C, SQLAgentUserRole, as this role specifically grants permissions to create and manage SQL Server Agent jobs. The other roles, such as Securityadmin and DatabaseMailUserRole, do not provide the necessary permissions for SQL Server Agent job management, while RSExecRole is primarily for report server execution permissions.