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.
You need to ensure that Azure AD identities can be used for authentication to the Azure SQL database.
Which of the following needs to be done as an initial step?
A. Assign an Azure policy.
B. Create a SQL Server Administrator with SQL based authentication.
C. Create a SQL Server Administrator based on an existing Azure AD Account.
D. Change the pricing tier for the database.
Correct Answer – C
You need to create a secondary SQL Server Administrator that is based on an Azure AD Account.
This is required before you can start creating users based on Azure AD Accounts in the SQL database.
The Microsoft documentation mentions the following.
Option A is incorrect since you don’t need an Azure policy to enable Azure AD Authentication for Azure SQL Databases.
Option B is incorrect since a secondary SQL Admin needs to be created based on an existing Azure AD Account.
Option D is incorrect since the pricing tier does not have an impact on this sort of requirement.
For more information on configuring Azure AD Authentication for SQL Server database, one can visit the below URL-
Comments are closed, but trackbacks and pingbacks are open.