nerdexam
Microsoft

AZ-500 · Question #231

You have an Azure subscription that contains four Azure SQL managed instances. You need to evaluate the vulnerability of the managed instances to SQL injection attacks. What should you do first?

The correct answer is B. Enable Advanced Data Security. To evaluate the vulnerability of Azure SQL managed instances to SQL injection attacks, the first step is to enable Advanced Data Security, which includes a dedicated vulnerability assessment tool.

Submitted by krish.m· Mar 6, 2026Secure compute, storage, and databases

Question

You have an Azure subscription that contains four Azure SQL managed instances. You need to evaluate the vulnerability of the managed instances to SQL injection attacks. What should you do first?

Options

  • ACreate an Azure Sentinel workspace.
  • BEnable Advanced Data Security.
  • CAdd the SQL Health Check solution to Azure Monitor.
  • DCreate an Azure Advanced Threat Protection (ATP) instance.

How the community answered

(26 responses)
  • A
    19% (5)
  • B
    69% (18)
  • C
    8% (2)
  • D
    4% (1)

Why each option

To evaluate the vulnerability of Azure SQL managed instances to SQL injection attacks, the first step is to enable Advanced Data Security, which includes a dedicated vulnerability assessment tool.

ACreate an Azure Sentinel workspace.

Azure Sentinel is a cloud-native SIEM solution for security information and event management, which analyzes security data but does not directly perform the initial vulnerability assessment for SQL injection on the database itself.

BEnable Advanced Data Security.Correct

Enabling Advanced Data Security for Azure SQL Managed Instances activates SQL Vulnerability Assessment, a service that scans the database for security misconfigurations and potential vulnerabilities, including SQL injection. This assessment provides actionable recommendations to mitigate identified risks.

CAdd the SQL Health Check solution to Azure Monitor.

The SQL Health Check solution in Azure Monitor typically focuses on performance, availability, and general health metrics rather than specifically assessing for SQL injection vulnerabilities.

DCreate an Azure Advanced Threat Protection (ATP) instance.

Azure Advanced Threat Protection (now Microsoft Defender for Identity) is primarily designed to protect Active Directory identities and detect identity-based threats, not to perform vulnerability assessments for SQL injection on databases.

Concept tested: Azure SQL Vulnerability Assessment for SQL Injection

Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-vulnerability-assessment

Topics

#SQL managed instance#vulnerability assessment#Advanced Data Security#SQL injection

Community Discussion

No community discussion yet for this question.

Full AZ-500 Practice