Which Azure service provides automatic threat detection and response for Azure SQL Database, detecting anomalous activities like SQL injection?
Microsoft Defender for SQL is a cloud-native security solution that provides advanced threat protection, including vulnerability assessments and security alerts for Azure SQL databases and SQL servers on VMs. It continuously monitors database activity to detect SQL injection, brute-force attacks, and anomalous access patterns, then delivers actionable alerts with investigation steps. This makes it specifically designed for the database-level threat detection described in the scenario.
Why this answer
Microsoft Defender for SQL is the correct answer because it is a cloud-native security solution specifically designed to detect and respond to threats against Azure SQL Database, including SQL injection attacks. It provides advanced threat protection by continuously monitoring database activities and generating security alerts for anomalous behaviors, such as unusual access patterns or injection attempts, without requiring manual intervention.
Exam trap
The trap here is that candidates often confuse Azure SQL Database auditing (which only logs events) with threat detection, or they mistakenly think Azure Firewall can inspect SQL traffic at the application layer, but it only filters based on IP/port rules and cannot parse SQL syntax.
How to eliminate wrong answers
Option A is wrong because Azure SQL Database auditing only logs database events for compliance and forensic analysis, but it does not actively detect or respond to threats like SQL injection in real time. Option C is wrong because Azure Policy is a governance tool that enforces organizational rules and compliance standards on Azure resources, but it lacks the capability to monitor database activity or detect security threats. Option D is wrong because Azure Firewall is a network security service that filters traffic at the network layer (OSI Layer 3/4) and cannot inspect SQL queries or detect application-layer attacks like SQL injection.