Crucial Exams

Microsoft Azure Security Engineer Associate AZ-500 Practice Question

An Azure App Service web app has a system-assigned managed identity. The app must connect to an existing Azure SQL Database named DB1 by using Microsoft Entra authentication and the principle of least privilege. After you sign in to DB1 with the configured Microsoft Entra administrator, which action should you perform so the web app can authenticate successfully?

  • Store a SQL authentication user name and password for DB1 in the web app's application settings.

  • Run CREATE USER [webAppName] FROM EXTERNAL PROVIDER; in DB1 and grant the required permissions.

  • In the master database, run CREATE LOGIN [webAppName] FROM EXTERNAL PROVIDER; and grant access to DB1.

  • Assign the web app's managed identity as the Microsoft Entra administrator for the SQL server.

Microsoft Azure Security Engineer Associate AZ-500
Secure compute, storage, and databases
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot