Quick Answer
The correct answer is to enable Microsoft Defender for Cloud for Azure SQL databases. This is because Defender for Cloud’s threat detection engine continuously monitors database access patterns and triggers SQL suspicious location alerts when it detects logins from unusual geographic regions, effectively identifying potential brute-force or credential-stuffing attacks. On the Microsoft Azure Security Engineer Associate AZ-500 exam, this concept tests your understanding that Defender for Cloud is the overarching security posture management service that activates advanced threat protection for Azure SQL, not a standalone feature like Advanced Threat Protection (which is simply the name of the detection capability within Defender for Cloud). A common trap is confusing Azure SQL Database auditing or Azure Firewall logs with alert generation—auditing only records activity, and firewalls filter traffic without analyzing SQL-specific anomalies. Remember the memory tip: “Defender detects, auditing records, firewalls block.”
This AZ-500 practice question tests your understanding of secure azure using microsoft defender for cloud and microsoft sentinel. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
An organization uses Microsoft Defender for Cloud to protect Azure SQL databases. They want to receive alerts when a SQL database is accessed from a suspicious location. What should they enable?
Enable Microsoft Defender for Cloud for Azure SQL databases
Defender for Cloud provides threat detection alerts for SQL databases.
Enable Azure Firewall on the SQL server
Why wrong: Firewall does not provide SQL-level threat detection.
Enable Azure SQL Database Advanced Threat Protection
Why wrong: ATP is a feature of Defender for Cloud, not a separate setting.
Enable Azure SQL Database Auditing
Why wrong: Auditing logs but does not alert.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Enable Microsoft Defender for Cloud for Azure SQL databases
Option D is correct because Microsoft Defender for Cloud for Azure SQL databases includes threat detection that alerts on anomalous access patterns, including suspicious locations. Option A is wrong because Advanced Threat Protection is the feature name, but it is enabled under Microsoft Defender for Cloud. Option B is wrong because Azure SQL Database auditing logs activity but does not generate alerts. Option C is wrong because Azure Firewall logs network traffic but does not generate SQL-specific alerts.
Key principle: NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
Enable Microsoft Defender for Cloud for Azure SQL databases
Why this is correct
Defender for Cloud provides threat detection alerts for SQL databases.
Related concept
Static NAT maps one inside address to one outside address.
Enable Azure Firewall on the SQL server
Why it's wrong here
Firewall does not provide SQL-level threat detection.
Enable Azure SQL Database Advanced Threat Protection
Why it's wrong here
ATP is a feature of Defender for Cloud, not a separate setting.
Enable Azure SQL Database Auditing
Why it's wrong here
Auditing logs but does not alert.
Common exam traps
NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.
Detailed technical explanation
NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.
Key takeaway
NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated.
Real-world example
A company's IT admin needs to give a contractor read-only access to production logs without sharing account credentials. Using role-based access control (RBAC) and temporary scoped permissions — not a permanent shared password — is the correct pattern. Questions like this test whether you can apply least-privilege access across cloud identity services.
What to study next
Review the four NAT address types (inside local, inside global, outside local, outside global), PAT port overload, and static vs dynamic NAT use cases. Then practise related AZ-500 NAT questions on configuration and troubleshooting.
Secure Azure using Microsoft Defender for Cloud and Microsoft Sentinel — study guide chapter
Learn the concepts, then practise the questions
Secure Azure using Microsoft Defender for Cloud and Microsoft Sentinel practice questions
Targeted practice on this topic area only
All AZ-500 questions
1,000 questions across all exam domains
Microsoft Azure Security Engineer Associate AZ-500 study guide
Full concept coverage aligned to exam objectives
AZ-500 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise AZ-500 questions linked to Secure identity and access.
Practise AZ-500 questions linked to Secure compute, storage, and databases.
Practise AZ-500 questions linked to Secure Azure using Microsoft Defender for Cloud and Microsoft Sentinel.
Practise AZ-500 questions linked to Manage identity and access.
Practise AZ-500 questions linked to Secure networking.
Practise AZ-500 questions linked to AZ-500 fundamentals.
Practise AZ-500 questions linked to AZ-500 scenario.
Practise AZ-500 questions linked to AZ-500 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Secure Azure using Microsoft Defender for Cloud and Microsoft Sentinel — This question tests Secure Azure using Microsoft Defender for Cloud and Microsoft Sentinel — Static NAT maps one inside address to one outside address..
The correct answer is: Enable Microsoft Defender for Cloud for Azure SQL databases — Option D is correct because Microsoft Defender for Cloud for Azure SQL databases includes threat detection that alerts on anomalous access patterns, including suspicious locations. Option A is wrong because Advanced Threat Protection is the feature name, but it is enabled under Microsoft Defender for Cloud. Option B is wrong because Azure SQL Database auditing logs activity but does not generate alerts. Option C is wrong because Azure Firewall logs network traffic but does not generate SQL-specific alerts.
Review the four NAT address types (inside local, inside global, outside local, outside global), PAT port overload, and static vs dynamic NAT use cases. Then practise related AZ-500 NAT questions on configuration and troubleshooting.
Static NAT maps one inside address to one outside address.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 20, 2026
This AZ-500 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the AZ-500 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.