Microsoft Azure Security Technologies — Question 25

You have been tasked with enabling Advanced Threat Protection for an Azure SQL Database server.
Advanced Threat Protection must be configured to identify all types of threat detection.
Which of the following will happen if when a faulty SQL statement is generate in the database by an application?

Answer options

• A. A Potential SQL injection alert is triggered.
• B. A Vulnerability to SQL injection alert is triggered.
• C. An Access from a potentially harmful application alert is triggered.
• D. A Brute force SQL credentials alert is triggered.

Correct answer: B

Explanation

The correct answer is B, as a faulty SQL statement can indicate a vulnerability to SQL injection, which Advanced Threat Protection is designed to detect. Option A is incorrect because it refers to an alert for a potential SQL injection, not a confirmed vulnerability. Options C and D relate to different types of threats that are not directly caused by a faulty SQL statement.