Azure AD Authentication Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Database Authentication

What you'll be asked

  1. Which of the following is a primary benefit of using Azure AD Authentication for Azure SQL Database instead of SQL Server Authentication?
  2. When configuring Azure AD Authentication for an Azure SQL Database, what is the mandatory first step that must be performed on the logical server?
  3. A developer needs to connect to an Azure SQL Database using a Managed Identity from an Azure App Service. Which connection string format is correct for this scenario?
  4. You have created an Azure AD user in the database using 'CREATE USER [[email protected]] FROM EXTERNAL PROVIDER;'. What is the final step required to allow this user to query data in a specific table?
  5. An application uses a Service Principal to connect to an Azure SQL Database. If the Service Principal is deleted from Azure AD, what happens to the database user associated with that identity?

Answers and explanations come after you submit.