You administer a Microsoft SQL Server 2012 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?
A.
DatabaseMailUserRole
B.
ServerGroupAdministratorGroup
C.
SQLAgentUserRole
D.
Securityadmin
Explanation:
SQLAgentUserRole is the least privileged of the SQL Server Agent fixed database roles. It has permissions on
only operators, local jobs, and job schedules. Members of SQLAgentUserRole have permissions on only local
jobs and job schedules that they own. Members can create local jobs.
https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles