Deal of The Day! 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

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?
A) sysadmin
B) SQLAgentUserRole
D) SQLAgentOperatorRole
C) SQLAgentReaderRole

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
Carylon
2 months ago
No, that role is too restrictive for configuring proxies.
upvoted 0 times
...
Rutha
2 months ago
But isn't SQLAgentReaderRole also an option?
upvoted 0 times
...
Dianne
2 months ago
Agreed, it allows limited access for job management.
upvoted 0 times
...
Benedict
2 months ago
I think User1 should get the SQLAgentUserRole.
upvoted 0 times
...
Donette
2 months ago
I thought you needed more permissions for proxy accounts?
upvoted 0 times
...
Kallie
2 months ago
Yep, least privilege is key here!
upvoted 0 times
...
Andrew
4 months ago
Wait, can User1 really do that with just that role?
upvoted 0 times
...
Cathrine
4 months ago
Totally agree, that's the right role for that!
upvoted 0 times
...
Ruby
4 months ago
You should assign the SQLAgentUserRole.
upvoted 0 times
...
Marshall
4 months ago
SQLAgentOperatorRole? That's a pretty good option for this problem.
upvoted 0 times
...
Dominque
5 months ago
SQLAgentOperatorRole - that's the one I'd pick for this use case.
upvoted 0 times
...
Hillary
5 months ago
SQLAgentOperatorRole? Sounds like a good fit for this requirement.
upvoted 0 times
...
Rebeca
5 months ago
SQLAgentOperatorRole is the most appropriate role for this task.
upvoted 0 times
...
Cherry
5 months ago
SQLAgentOperatorRole is the way to go for this scenario.
upvoted 0 times
...
Felton
5 months ago
I'd go with SQLAgentOperatorRole to give User1 the necessary permissions.
upvoted 0 times
...
Lanie
5 months ago
SQLAgent_OperatorRole seems like the right choice here.
upvoted 0 times
...
Delsie
6 months ago
I’m a bit confused; I thought only sysadmin could manage proxy accounts, but maybe there's a specific role for that?
upvoted 0 times
...
Brittni
6 months ago
I practiced a similar question where we had to assign roles for job management, and I think the SQLAgentOperatorRole could be relevant here.
upvoted 0 times
...
Buffy
7 months 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
7 months 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
7 months 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
7 months 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
7 months 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
7 months 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
8 months 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
Ressie
30 days ago
SQLAgentUserRole is definitely the least privilege option here.
upvoted 0 times
...
Almeta
1 month ago
That makes sense, but what about SQLAgentOperatorRole?
upvoted 0 times
...
Elizabeth
1 month ago
I think User1 needs the SQLAgentUserRole.
upvoted 0 times
...
...

Save Cancel