DP-300 · Question #275
DP-300 Question #275: Real Exam Question with Answer & Explanation
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: SQLAgentUserRol
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
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
Community Discussion
No community discussion yet for this question.