Exam DP-300 topic 2 question 22 discussion

Actual exam question from Microsoft's DP-300

Question #: 22
Topic #: 2

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

A. db_owner
B. dbmanager
C. dbo
D. db_ddladmin

Show Suggested Answer

Suggested Answer: B 🗳️
dbmanager: Can create and delete databases. A member of the dbmanager role that creates a database, becomes the owner of that database, which allows that user to connect to that database as the dbo user. The dbo user has all database permissions in the database. Members of the dbmanager role don't necessarily have permission to access databases that they don't own.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles

by QuanPham9695 at Sept. 29, 2022, 2:36 p.m.

Comments

Submit Cancel

OCP

11 months, 1 week ago

The answer is correct. The key word is in the question is master database, the dbmanager role exists in the virtual master database and allows members to create and delete databases.

upvoted 2 times

...