Crucial Exams

Microsoft Azure Security Engineer Associate AZ-500 Practice Question

You manage an Azure SQL Database server named sql1 that hosts several production databases. You must enable Microsoft Entra (Azure AD) authentication so that members of an Azure AD group named SQLSecAdmins can connect to any database on the server. What should you do first?

  • Assign the SQLSecAdmins group the Contributor role on the sql1 resource.

  • In each database on sql1, run CREATE USER [SQLSecAdmins] FROM EXTERNAL PROVIDER.

  • Configure an Azure AD administrator for sql1 and set the administrator to the SQLSecAdmins group.

  • Enable the Allow access to Azure services firewall rule on sql1.

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