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

Microsoft DP-300 Exam - Topic 5 Question 124 Discussion

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

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?

Suggested Answer: A

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test
28 comments · newest first
CA
Carylon 4 months ago
No, that role is too restrictive for configuring proxies.
RU
Rutha 4 months ago
But isn't SQLAgentReaderRole also an option?
DI
Dianne 4 months ago
Agreed, it allows limited access for job management.
BE
Benedict 4 months ago
I think User1 should get the SQLAgentUserRole.
DO
Donette 4 months ago
I thought you needed more permissions for proxy accounts?
KA
Kallie 5 months ago
Yep, least privilege is key here!
AN
Andrew 6 months ago
Wait, can User1 really do that with just that role?
CA
Cathrine 6 months ago
Totally agree, that's the right role for that!
RU
Ruby 6 months ago
You should assign the SQLAgentUserRole.
MA
Marshall 7 months ago
SQLAgentOperatorRole? That's a pretty good option for this problem.
DO
Dominque 7 months ago
SQLAgentOperatorRole - that's the one I'd pick for this use case.
HI
Hillary 7 months ago
SQLAgentOperatorRole? Sounds like a good fit for this requirement.
RE
Rebeca 7 months ago
SQLAgentOperatorRole is the most appropriate role for this task.
CH
Cherry 7 months ago
SQLAgentOperatorRole is the way to go for this scenario.
FE
Felton 7 months ago
I'd go with SQLAgentOperatorRole to give User1 the necessary permissions.
LA
Lanie 8 months ago
SQLAgent_OperatorRole seems like the right choice here.
DE
Delsie 8 months ago
I’m a bit confused; I thought only sysadmin could manage proxy accounts, but maybe there's a specific role for that?
BR
Brittni 8 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.
BU
Buffy 9 months ago
I remember something about the SQLAgentReaderRole being related to job permissions, but I don't think it allows configuring proxy accounts.
PE
Peggie 9 months ago
I think User1 might need the SQLAgentUserRole, but I'm not entirely sure if that's the least privilege option.
DA
Daniel 9 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.
IZ
Izetta 9 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.
SA
Sage 9 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.
RU
Ruthann 10 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.
SH
Shayne 10 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.
RE
Ressie 3 months ago
↳ replying to Shayne
SQLAgentUserRole is definitely the least privilege option here.
AL
Almeta 3 months ago
↳ replying to Shayne
That makes sense, but what about SQLAgentOperatorRole?
EL
Elizabeth 4 months ago
↳ replying to Shayne
I think User1 needs the SQLAgentUserRole.
0/2000 characters

Save Cancel