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.
Question
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)- A19% (5)
- B69% (18)
- C8% (2)
- D4% (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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.