DP-300 Certification Practice Question #66

Question

You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1.
The only user who was created is the server administrator.
You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Accepted Answer

To create a contained database user in `DB1` authenticated by Azure AD (Microsoft Entra), you must first configure a Microsoft Entra administrator (Active Directory Admin) for the server `AzSQL1` in the Azure portal. Then, you must connect to `DB1` using that Active Directory admin account; standard SQL admin logins do not have permissions to contact Microsoft Entra ID to validate identities. Finally, once connected as the AD admin, you run the T-SQL statement to create the database user using the `FROM EXTERNAL PROVIDER` clause.

More DP-300 practice questions