Enabling Microsoft Entra Database Authentication

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

Quiz covering Security for Azure SQL

What you'll be asked

  1. Which identity type must be configured as the Azure SQL server administrator to enable Microsoft Entra authentication?
  2. After setting the Entra admin for an Azure SQL server, what is the mandatory next step to allow a specific Entra user to access a database?
  3. Which of the following is a key security advantage of using Microsoft Entra authentication over SQL Authentication for Azure SQL?
  4. A developer is attempting to connect to Azure SQL using Entra ID, but receives an authentication error despite having the correct credentials. What is a common requirement that might have been overlooked?
  5. You have a Managed Identity assigned to an Azure Function that needs to access Azure SQL. If you want the Function to access the database without managing credentials in the code, how should you configure the database access?

Answers and explanations come after you submit.