You have an instance of SQL Server on Azure Virtual Machines. You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle…

The correct answer is A. sysadmin. Only members of the sysadmin fixed server role have permission to create, modify, or delete Users who are not members of the sysadmin fixed server role must be added to one of the following SQL Server Agent fixed database roles in the msdb database to use proxies…

Submitted by saadiq_pk· Mar 6, 2026Configure and manage automation of tasks

Question

You have an instance of SQL Server on Azure Virtual Machines. You need to ensure that a user named User1 can configure proxy accounts for SQL Server Agent jobs. The solution must use the principle of least privilege. Which role should you assign to User1?

Options

Asysadmin
BSQLAgentUserRole
CSQLAgentReaderRole
DSQLAgentOperatorRole

How the community answered

(41 responses)

A
85% (35)
B
2% (1)
C
5% (2)
D
7% (3)

Explanation

Only members of the sysadmin fixed server role have permission to create, modify, or delete Users who are not members of the sysadmin fixed server role must be added to one of the following SQL Server Agent fixed database roles in the msdb database to use proxies: SQLAgentUserRole, SQLAgentReaderRole, or SQLAgentOperatorRole. https://learn.microsoft.com/en-us/sql/ssms/agent/create-a-sql-server-agent-proxy?view=sql- server-ver16#Permissions

Topics

#SQL Server Agent#proxy accounts#sysadmin#least privilege

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice