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 6 Question 103 Discussion

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.You need to ensure that User! can create a scheduled task to perform a full backup of DB1. The solution must use the principle of least privilege.Which built-in database role should you assign to User1?
C) SQLAgentOperatorRole
A) SQLAgentReaderRole
B) db.owner
D) SQLAgentUserRole

Microsoft DP-300 Exam - Topic 6 Question 103 Discussion

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

You have an Azure subscription that contains an instance of SQL Server on an Azure virtual machine named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.

You need to ensure that User! can create a scheduled task to perform a full backup of DB1. The solution must use the principle of least privilege.

Which built-in database role should you assign to User1?

Show Suggested Answer Hide Answer
Suggested Answer: C

by Shenika at Sep 15, 2024, 06:19 AM

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
Larue
10 months ago
Wait, can User1 really create a backup task with just that role? Seems too limited.
upvoted 0 times
...
Casie
10 months ago
I agree, SQLAgentUserRole is the safest option!
upvoted 0 times
...
Rossana
10 months ago
SQLAgentOperatorRole sounds good too, but not sure if it's least privilege.
upvoted 0 times
...
Odette
10 months ago
Definitely not db.owner, that's too much access!
upvoted 0 times
...
Dewitt
10 months ago
I think SQLAgentUserRole is the right choice here.
upvoted 0 times
...
Nelida
11 months ago
I’m leaning towards SQLAgentUserRole as well, but I wonder if SQLAgentReaderRole could work too since it’s about reading job information.
upvoted 0 times
...
Matthew
11 months ago
I feel like db.owner is definitely too broad for this scenario; we should stick to the least privilege principle.
upvoted 0 times
...
Raymon
11 months ago
I remember practicing a similar question, and I think the SQLAgentOperatorRole might be too much access for just creating a backup task.
upvoted 0 times
...
Emelda
11 months ago
I think User1 needs the SQLAgentUserRole since it allows creating jobs, but I'm not entirely sure if that's the best choice for backups.
upvoted 0 times
...
Viva
11 months ago
I'm a bit confused by the different SQL Server roles listed here. I'll need to review the details of each one to determine which one would allow User1 to create the scheduled backup task without giving them unnecessary permissions.
upvoted 0 times
...
Lang
11 months ago
The question mentions the principle of least privilege, so I'm guessing we want to give User1 the minimum permissions required to accomplish the task. Based on the options, the SQLAgentUserRole seems like the best fit since it's specifically for managing SQL Agent jobs.
upvoted 0 times
...
Kenneth
11 months ago
Hmm, I'm not entirely sure about this one. I know we need to give User1 the ability to create a scheduled task, but I'm not familiar with the different SQL Server database roles. I'll have to think this through carefully.
upvoted 0 times
...
Alonzo
11 months ago
This seems straightforward. I think the SQLAgentUserRole is the right choice to give User1 the ability to create a scheduled task for the database backup, while still following the principle of least privilege.
upvoted 0 times
...
Hershel
12 months ago
I'm a bit confused by the options here. Connecting Spine2 to ISN routers and configuring BIDIR-PIM don't seem directly relevant to the Cisco ACI Multi-Site setup. I'll need to think this through more carefully.
upvoted 0 times
...
Stephanie
2 years ago
Why do you think that? I thought SQLAgentOperatorRole would be the best option for least privilege.
upvoted 0 times
...
Britt
2 years ago
Hold up, I think I saw this question before. SQLAgentReaderRole sounds familiar, but I can't remember if that's the right one. Hmm...
upvoted 0 times
...
Pedro
2 years ago
I disagree, I believe the correct answer is D) SQLAgentUserRole.
upvoted 0 times
...
Daron
2 years ago
Wait, isn't db.owner a bit too much? I mean, we just need to create a backup task, not become the database owner.
upvoted 0 times
...
Dalene
2 years ago
Nah, I think it's SQLAgentUserRole. That's the one with the least privileges, so it fits the 'principle of least privilege' requirement.
upvoted 0 times
Pete
2 years ago
I believe SQLAgentReaderRole would be the most appropriate role for User1 in this scenario.
upvoted 0 times
...
Glenn
2 years ago
I think SQLAgentOperatorRole might be a better option for User1 to create scheduled tasks.
upvoted 0 times
...
Viola
2 years ago
I agree, SQLAgentUserRole is the correct choice for least privilege access.
upvoted 0 times
...
...
Stephanie
2 years ago
I think the answer is C) SQLAgentOperatorRole.
upvoted 0 times
...
Ocie
2 years ago
C'mon, it's gotta be SQLAgentOperatorRole. That's the one that lets you manage SQL Agent jobs, right?
upvoted 0 times
Levi
2 years ago
Actually, I agree with you. SQLAgentOperatorRole is the most suitable role for User1 to create a scheduled task for a full backup of DB1.
upvoted 0 times
...
Arthur
2 years ago
I think SQLAgentReaderRole would be the best option. It only allows the user to view SQL Agent jobs, not create or manage them.
upvoted 0 times
...
Kati
2 years ago
But wouldn't SQLAgentUserRole be more appropriate? It only allows the user to create and manage their own jobs.
upvoted 0 times
...
Lorean
2 years ago
Yes, you are correct! SQLAgentOperatorRole is the role that allows User1 to create and manage SQL Agent jobs.
upvoted 0 times
...
...

Save Cancel