nerdexam
Microsoft

DP-300 · Question #278

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and an Azure Active Directory Domain Services (Azure AD DS) domain that contains two…

The correct answer is D. sysadmin. https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-

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

Question

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named VM1 and an Azure Active Directory Domain Services (Azure AD DS) domain that contains two users named User1 and User 2. On the default instance of SQL Server on VM1, you create a credential named Credential1 for User1. You need to ensure that User2 can create a SQL Server Agent proxy that will use Credential1. The solution must use the principle of least privilege. Which role should you assign to User2?

Options

  • ASQLAgentUserRole
  • BSQLAgentReaderRole
  • CSQLAgentOperatorRole
  • Dsysadmin

How the community answered

(42 responses)
  • A
    14% (6)
  • B
    2% (1)
  • C
    7% (3)
  • D
    76% (32)

Explanation

https://learn.microsoft.com/en-us/sql/ssms/agent/sql-server-agent-fixed-database-roles?view=sql-

Topics

#SQL Server Agent#proxy creation#credentials#sysadmin role

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice