Microsoft
DP-300 · Question #50
Drag and Drop 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 databa
Sign in or unlock DP-300 to reveal the answer and full explanation for question #50. The question stem and answer options stay visible for context.
Submitted by salim_om· Mar 6, 2026Implement and manage data platform security - specifically configuring Azure AD authentication and creating contained database users in Azure SQL Database
Question
Drag and Drop 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. Answer:
Exhibit
Answer Area
Drag items
Connect to DB1 by using the Active Directory admin account.Create a user by using the FROM EXTERNAL PROVIDER clause.Connect to DB1 by using the server administrator account.Set the Active Directory Admin for AzSQL1.From the Azure portal, assign the SQL DB Contributor role to the user.Create a login in the master database.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Azure SQL Database#Azure Active Directory Authentication#Contained Database Users#Database Security