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…

The correct answer is B. dbmanager. 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…

Submitted by chen.hong· Mar 6, 2026Implement a secure environment

Question

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?

Options

Adb_owner
Bdbmanager
Cdbo
Ddb_ddladmin

How the community answered

(21 responses)

B
90% (19)
C
5% (1)
D
5% (1)

Explanation

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 https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication- access/database-level-roles

Community Discussion

No community discussion yet for this question.

Full DP-300 Practice