Microsoft Exam DP-300 Topic 6 Question 103 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 103
Topic #: 6

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?

ASQLAgentReaderRole

Bdb.owner

CSQLAgentOperatorRole

DSQLAgentUserRole

Show Suggested 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

9 months ago

Why do you think that? I thought SQLAgentOperatorRole would be the best option for least privilege.

upvoted 0 times

...

Britt

9 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

9 months ago

I disagree, I believe the correct answer is D) SQLAgentUserRole.

upvoted 0 times

...

Daron

9 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

9 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

8 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

8 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

9 months ago

Yes, you are correct! SQLAgentOperatorRole is the role that allows User1 to create and manage SQL Agent jobs.

upvoted 0 times

...