DP-300 · Question #205
You are training a new administrator for your company's Azure data services, which includes database deployed on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure virtual…
The correct answer is C. dbmanager E. loginmanager. The dbmanager and loginmanager roles are unique server-level roles specifically introduced for Azure SQL Database to manage databases and logins, respectively, and are not present in other SQL deployment options like SQL Server on Azure VMs or Azure SQL Managed Instance.
Question
Options
- Adb_securityadmin
- Bsysadmin
- Cdbmanager
- Ddbcreator
- Eloginmanager
How the community answered
(16 responses)- B6% (1)
- C94% (15)
Why each option
The `dbmanager` and `loginmanager` roles are unique server-level roles specifically introduced for Azure SQL Database to manage databases and logins, respectively, and are not present in other SQL deployment options like SQL Server on Azure VMs or Azure SQL Managed Instance.
The `db_securityadmin` is a standard database-level fixed role available across SQL Server, Azure SQL Database, and Azure SQL Managed Instance, and is not exclusive to Azure SQL Database.
The `sysadmin` server-level fixed role is available in SQL Server on Azure VMs and Azure SQL Managed Instance, but it is not available for user assignment within Azure SQL Database due to its PaaS architecture.
The `dbmanager` role is a server-level role in Azure SQL Database that grants the ability to create and delete databases, a functionality managed differently in full SQL Server instances like Azure SQL Managed Instance or SQL Server on Azure VMs.
The `dbcreator` server-level fixed role is available in SQL Server on Azure VMs and Azure SQL Managed Instance, but it is not a direct role for users in Azure SQL Database, where database creation is handled by the `dbmanager` role.
The `loginmanager` role is a server-level role in Azure SQL Database that provides permissions to create and delete logins, which distinguishes its login management from that of SQL Server on Azure VMs and Azure SQL Managed Instance.
Concept tested: Azure SQL Database unique server roles
Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/permissions-database-roles?view=azuresql
Community Discussion
No community discussion yet for this question.