nerdexam
Microsoft

AZ-500 · Question #157

SIMULATION You need to ensure that a user named Danny11597200 can sign in to any SQL database on a Microsoft SQL server named web11597200 by using SQL Server Management Studio (SSMS) and Azure…

The correct answer is B. an Azure Desired State Configuration (DSC) virtual machine extension. There appears to be a significant mismatch between the question, the correct answer, and the provided options. The question asks about enabling Azure AD authentication for SQL Server via SSMS, and the detailed answer correctly describes provisioning an Azure AD Admin through…

Submitted by carter_n· Mar 6, 2026Configure Azure AD authentication for Azure SQL Server to enable users to sign in using their Azure AD credentials via SSMS - typically falls under 'Implement and Manage Identity and Access' or 'Configure Access to Azure Resources' in Azure Administrator (AZ-104) certification domains.

Question

SIMULATION You need to ensure that a user named Danny11597200 can sign in to any SQL database on a Microsoft SQL server named web11597200 by using SQL Server Management Studio (SSMS) and Azure Active Directory (Azure AD) credentials. To complete this task, sign in to the Azure portal. Answer: You need to provision an Azure AD Admin for the SQL Server. 1. In the Azure portal, type SQL Server in the search box, select SQL Server from the search results then select the server named web11597200. Alternatively, browse to SQL Server in the left navigation pane. 2. In the SQL Server properties page, click on Active Directory Admin. 3. Click the Set Admin button. 4. In the Add Admin window, search for and select Danny11597200. 5. Click the Select button to add Danny11597200. 6. Click the Save button to save the changes. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad- configure?tabs=azure-powershell

Options

  • Adevice configuration policies in Microsoft Intune
  • Ban Azure Desired State Configuration (DSC) virtual machine extension
  • Csecurity policies in Azure Security Center
  • DAzure Logic Apps

How the community answered

(45 responses)
  • A
    2% (1)
  • B
    91% (41)
  • C
    2% (1)
  • D
    4% (2)

Explanation

There appears to be a significant mismatch between the question, the correct answer, and the provided options. The question asks about enabling Azure AD authentication for SQL Server via SSMS, and the detailed answer correctly describes provisioning an Azure AD Admin through the Azure portal. However, the options (A-D) and the marked correct answer (B - Azure DSC VM extension) are completely unrelated to SQL Server Azure AD authentication. This appears to be a corrupted or mismatched question set. In the context of the detailed solution provided, the correct approach is to set an Azure AD Admin on the SQL Server, which allows Azure AD-based sign-in via SSMS.

Topics

#Azure SQL Server#Azure Active Directory Authentication#SQL Server Management Studio#Identity Management

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-500 Practice