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 Exam DP-300 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:

Submit Cancel
Stephanie
8 months ago
Why do you think that? I thought SQLAgentOperatorRole would be the best option for least privilege.
upvoted 0 times
...
Britt
8 months 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
8 months ago
I disagree, I believe the correct answer is D) SQLAgentUserRole.
upvoted 0 times
...
Daron
8 months 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
9 months 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
8 months ago
I believe SQLAgentReaderRole would be the most appropriate role for User1 in this scenario.
upvoted 0 times
...
Glenn
8 months ago
I think SQLAgentOperatorRole might be a better option for User1 to create scheduled tasks.
upvoted 0 times
...
Viola
8 months ago
I agree, SQLAgentUserRole is the correct choice for least privilege access.
upvoted 0 times
...
...
Stephanie
9 months ago
I think the answer is C) SQLAgentOperatorRole.
upvoted 0 times
...
Ocie
9 months ago
C'mon, it's gotta be SQLAgentOperatorRole. That's the one that lets you manage SQL Agent jobs, right?
upvoted 0 times
Levi
7 months 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
7 months 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
8 months ago
But wouldn't SQLAgentUserRole be more appropriate? It only allows the user to create and manage their own jobs.
upvoted 0 times
...
Lorean
8 months ago
Yes, you are correct! SQLAgentOperatorRole is the role that allows User1 to create and manage SQL Agent jobs.
upvoted 0 times
...
...

Save Cancel