Microsoft DP-300 Exam - Topic 3 Question 59 Discussion

Actual exam question for Microsoft's DP-300 exam

Question #: 59
Topic #: 3

You have an Azure subscription that contains a logical SQL server named Serverl. The master database of Serverl contains a user named Userl. You need to ensure that Userl can create databases on Serverl. Which database role should you assign to Userl?

Adb_owner

Bdbmanager

Cdbo

Ddb_ddladmin

Show Suggested Answer

Suggested Answer: B

by Quentin at Aug 19, 2022, 06:33 AM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Colette

7 months ago

Nah, db_ddladmin doesn't cut it for this task.

upvoted 0 times

...

Remona

7 months ago

I thought dbo was the only option for that!

upvoted 0 times

...

Giuseppe

7 months ago

Wait, can db_owner create databases too?

upvoted 0 times

...

Detra

8 months ago

Totally agree, dbmanager is the way to go!

upvoted 0 times

...

Evangelina

8 months ago

You should assign the dbmanager role to User1.

upvoted 0 times

...

Lai

8 months ago

I’m a bit confused; I thought dbo was the main role, but it seems like that might not be what we need here.

upvoted 0 times

...

Cheryl

8 months ago

I feel like I saw a question like this before, and it was about assigning roles. I think dbmanager is specifically for database creation.

upvoted 0 times

...

William

8 months ago

I remember something about db_owner being too broad for just creating databases. Maybe dbmanager is the right choice?

upvoted 0 times

...

Oliva

8 months ago

I think User1 needs the dbmanager role to create databases, but I'm not entirely sure.

upvoted 0 times

...

Jaime

8 months ago

This seems like a straightforward question about high availability and minimizing traffic disruptions. I'll carefully review the options and think through the implications of each one.

upvoted 0 times

...

Gladis

8 months ago

Hmm, this is a tough one. The broad criteria sound like they could fit a bonus program, but I'm not totally sure. I'll have to review my notes on the different types of variable pay.

upvoted 0 times

...

Micheline

8 months ago

I'm a bit confused by the different options here. I know we need to start the agent, but I'm not sure if the port number is required or not. I'll have to carefully read through each choice to determine the best answer.

upvoted 0 times

...