Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsiri.com
Question : 11 of 40
Marks:
+1,
-0
DRAG DROP
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:
Actions :
1. Connect to DB1 by using the Active Directory admin account.
2. Create a user by using the FROM EXTERNAL PROVIDER clause.
3.Connect to DB1 by using the server administrator account.
4. Set the Active Directory Admin for AzSQL1.
5. From the Azure portal, assign the SQL DB Contributor role to the user.
6. Create a login in the master database.
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:
Actions :
1. Connect to DB1 by using the Active Directory admin account.
2. Create a user by using the FROM EXTERNAL PROVIDER clause.
3.Connect to DB1 by using the server administrator account.
4. Set the Active Directory Admin for AzSQL1.
5. From the Azure portal, assign the SQL DB Contributor role to the user.
6. Create a login in the master database.
Go to Question: