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
SQLAgentUserRole is definitely the least privilege option here.
AL
Almeta
3 months ago
That makes sense, but what about SQLAgentOperatorRole?
EL
Elizabeth
4 months ago
I think User1 needs the SQLAgentUserRole.