New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 5 Question 124 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 124
Topic #: 5
[All DP-300 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Jerry at Jan 22, 2026, 09:27 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Buffy
5 days ago
I remember something about the SQLAgentReaderRole being related to job permissions, but I don't think it allows configuring proxy accounts.
upvoted 0 times
...
Peggie
10 days ago
I think User1 might need the SQLAgentUserRole, but I'm not entirely sure if that's the least privilege option.
upvoted 0 times
...
Daniel
15 days ago
Hmm, I'm not 100% sure on this one. I'll need to double-check the SQL Server Agent role definitions to make sure I assign the right one to User1 while following the principle of least privilege.
upvoted 0 times
...
Izetta
20 days ago
This seems pretty straightforward. I'm pretty sure the "SQLAgentUserRole" would be the right one to give User1 the permissions they need without granting too much access.
upvoted 0 times
...
Sage
25 days ago
I'm a bit confused on the specifics of SQL Server Agent roles and how they map to the ability to configure proxy accounts. I'll need to review the documentation to make sure I understand this properly.
upvoted 0 times
...
Ruthann
1 month ago
Okay, I remember learning about SQL Server Agent roles in class. I think the "SQLAgentOperatorRole" might be the one I want to assign to User1 to give them the least amount of privilege needed.
upvoted 0 times
...
Shayne
1 month ago
Hmm, this seems like a pretty straightforward permissions question. I'll need to think about the different SQL Server Agent roles and which one would give User1 the ability to configure proxy accounts.
upvoted 0 times
...

Save Cancel