MENU
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?
Suggested Answer: B
Get Premium DP-300 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
12 comments · newest first
CO
Colette
11 months ago
Nah, db_ddladmin doesn't cut it for this task.
RE
Remona
11 months ago
I thought dbo was the only option for that!
GI
Giuseppe
12 months ago
Wait, can db_owner create databases too?
DE
Detra
12 months ago
Totally agree, dbmanager is the way to go!
EV
Evangelina
1 year ago
You should assign the dbmanager role to User1.
LA
Lai
1 year 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.
CH
Cheryl
1 year 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.
WI
William
1 year ago
I remember something about db_owner being too broad for just creating databases. Maybe dbmanager is the right choice?
OL
Oliva
1 year ago
I think User1 needs the dbmanager role to create databases, but I'm not entirely sure.
JA
Jaime
1 year 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.
GL
Gladis
1 year 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.
MI
Micheline
1 year 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.