A company runs Microsoft SQL Server in an on-premises virtual machine (VM).
You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD).
You need to configure Azure SQL Database to use an Azure AD user as administrator.
What should you configure?
Click on the arrows to vote for the correct answer
A. B. C. D.C
There are two administrative accounts (Server admin and Active Directory admin) that act as administrators.
One Azure Active Directory account, either an individual or security group account, can also be configured as an administrator. It is optional to configure an Azure
AD administrator, but an Azure AD administrator must be configured if you want to use Azure AD accounts to connect to SQL Database.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-manage-loginsTo configure Azure SQL Database to use an Azure AD user as administrator, you need to perform the following steps:
Create an Azure AD user: First, you need to create an Azure AD user that you want to use as an administrator for Azure SQL Database. This user will be synchronized from your on-premises Active Directory to Azure AD.
Assign the Azure AD user to the Active Directory administrator role: Next, you need to assign the Azure AD user to the Active Directory administrator role. This role provides permissions to manage Azure SQL Database resources.
Add the Azure AD user as an administrator to Azure SQL Database: Finally, you need to add the Azure AD user as an administrator to Azure SQL Database. This will give the user full control over the database, including the ability to create, modify, and delete database objects.
Now let's take a look at the answer choices:
A. For each Azure SQL Database, set the Access Control to administrator. This answer is incorrect because setting Access Control to administrator does not configure Azure SQL Database to use an Azure AD user as administrator.
B. For each Azure SQL Database server, set the Active Directory to administrator. This answer is incorrect because setting Active Directory to administrator does not configure Azure SQL Database to use an Azure AD user as administrator.
C. For each Azure SQL Database, set the Active Directory administrator role. This answer is correct. You need to assign the Azure AD user to the Active Directory administrator role to provide permissions to manage Azure SQL Database resources.
D. For each Azure SQL Database server, set the Access Control to administrator. This answer is incorrect because setting Access Control to administrator does not configure Azure SQL Database to use an Azure AD user as administrator.
Therefore, the correct answer is C. For each Azure SQL Database, set the Active Directory administrator role.