called whizlabserver1000. You have to create a contained database user in the database based on an Azure AD user. Which of the following would you execute for this requirement? (Choose 3 answers)

Question

Options

• AConnect to the database by using the Active Directory account admin account
• BCreate a user by using the FROM EXTERNAL PROVIDER clause
• CConnect to the database by using a server administrator account
• DSet the Active Directory Admin for the Azure SQL Server
• EFrom the Azure portal, assign the SQL DB Contributor role to the user

• A
  73% (24)
• C
  9% (3)
• E
  18% (6)

Explanation

First, you need to set the Active Directory Admin for the Azure SQL Server. The next step is to connect to the database with the Active Directory account admin account. And then finally create the contained database user by using the FROM EXTERNAL PROVIDER Option C is incorrect because you need to connect to the database using the Active Directory account admin account Option E is incorrect because you don't need to assign any RBAC role to the user https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad- configure?tabs=azure-powershell

No community discussion yet for this question.