Implementing an Azure Data Solution (legacy) — Question 1

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?

Answer options

• A. For each Azure SQL Database, set the Access Control to administrator.
• B. For each Azure SQL Database server, set the Active Directory to administrator.
• C. For each Azure SQL Database, set the Active Directory administrator role.
• D. For each Azure SQL Database server, set the Access Control to administrator.

Correct answer: C

Explanation

The correct answer is C because you need to assign an Azure AD user as an Active Directory administrator specifically for each Azure SQL Database. Options A and D incorrectly refer to Access Control, while option B does not specify the correct role needed for Azure SQL Database.