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 3 Question 59 Discussion

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?
B) dbmanager
A) db_owner
C) dbo
D) db_ddladmin

Microsoft DP-300 Exam - Topic 3 Question 59 Discussion

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

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Colette
10 months ago
Nah, db_ddladmin doesn't cut it for this task.
upvoted 0 times
...
Remona
10 months ago
I thought dbo was the only option for that!
upvoted 0 times
...
Giuseppe
10 months ago
Wait, can db_owner create databases too?
upvoted 0 times
...
Detra
10 months ago
Totally agree, dbmanager is the way to go!
upvoted 0 times
...
Evangelina
10 months ago
You should assign the dbmanager role to User1.
upvoted 0 times
...
Lai
11 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
11 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
11 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
11 months ago
I think User1 needs the dbmanager role to create databases, but I'm not entirely sure.
upvoted 0 times
...
Jaime
11 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
11 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
11 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
...

Save Cancel