DP-300 Certification Practice Question #85

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?

Accepted Answer

Azure SQL Database includes special database-level roles that exist only in the virtual `master` database to handle server management tasks. The `dbmanager` role provides permission to create and delete databases on the logical server. The other choices (`db_owner`, `dbo`, and `db_ddladmin`) are standard database-level roles or principals that exist within individual user databases and do not grant permission to create new databases on the server.

More DP-300 practice questions