nerdexam
Microsoft

DP-300 · Question #275

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

Sign in or unlock DP-300 to reveal the answer and full explanation for question #275. The question stem and answer options stay visible for context.

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

Unlock DP-300 to see the answer

You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#SQL Server Agent#proxy accounts#sysadmin#least privilege
Full DP-300 Practice