Practice Test 3 | Microsoft Azure Security Technologies | AZ-500 | Dumps | Mock Test
A company has an Azure SQL database defined as part of their subscription.
You have to prepare the database to authenticate by using identities defined in their Azure AD tenant.
Which of the following statement can be used to create a contained user based on Azure AD in a SQL database?
A. CREATE USER “dbusr” for LOGIN “dbusr”
B. CREATE USER “dbusr@demousr2016gmail.onmicrosoft.com” for LOGIN “dbusr”
C. CREATE USER “dbusr” FROM EXTERNAL PROVIDER
D. CREATE USER “dbusr@demousr2016gmail.onmicrosoft.com” FROM EXTERNAL PROVIDER
Answer – D
When you create a contained user based on an Azure AD Account, you have to use the clause of “EXTERNAL PROVIDER”. The Microsoft documentation mentions the following.
Options A and B are incorrect since you need to use the “FROM EXTERNAL PROVIDER” clause.
Option C is incorrect since you need to mention the entire User Principal name in Azure AD.
For more information on configuring Azure AD Authentication for SQL Server database, one can visit the below URL-
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-aad-authentication-configure
Comments are closed, but trackbacks and pingbacks are open.