Question 214 of 1,639

Mitigate threats using Microsoft Defender for Cloud →hardMultiple ChoiceObjective-mapped

Quick Answer

The correct answer is to use Data Discovery & Classification in Azure SQL to label sensitive columns, then configure Advanced Threat Protection to alert only when a SQL injection event is detected against a database with those labels. This works because Data Discovery & Classification natively tags columns containing sensitive data like credit card numbers, and Advanced Threat Protection (ATP) can filter its SQL injection alerts based on those classification labels—so alerts fire only when the targeted database actually holds sensitive information. On the SC-200 exam, this tests your understanding of integrating Azure SQL’s built-in classification with Defender for Cloud’s alert logic, rather than manually managing per-database rules. A common trap is assuming you must enable ATP on every database and then filter alerts externally, which adds overhead. Remember the mnemonic: “Classify first, then alert—labels do the filtering work.”

SC-200 Practice Question: Mitigate threats using Microsoft Defender for Cloud

This SC-200 practice question tests your understanding of mitigate threats using microsoft defender for cloud. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. 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.

A security analyst uses Microsoft Defender for Cloud to monitor Azure SQL Databases. The analyst wants to generate alerts for SQL injection attempts but only for databases that contain sensitive data (e.g., credit card numbers). What is the most efficient way to configure alerting to focus on these databases?

Question 1hardmultiple choice

Full question →

A
Enable a custom alert rule in Microsoft Sentinel that queries Azure SQL audit logs and filters based on database classification tags.
Why wrong: This is complex and less efficient; Defender for Cloud provides built-in capabilities that integrate with data classification.
B
Use Data Discovery & Classification in Azure SQL to label sensitive columns, then configure Advanced Threat Protection to alert only when a SQL injection event is detected against a database with those labels.
Correct. SQL ATP can be linked with data classification to focus alerts on databases containing sensitive data, reducing noise.
C
Disable Advanced Threat Protection for all databases except those that contain sensitive data by manually enabling ATP per database.
Why wrong: Incorrect. While possible, this is not scalable and requires manual maintenance as databases are added or classification changes.
D
Create a workflow automation in Defender for Cloud that filters SQL injection alerts based on database name.
Why wrong: Incorrect. Workflow automation runs after an alert is generated; it does not prevent alerts on non-sensitive databases.

Full breakdown with real-world context →

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Use Data Discovery & Classification in Azure SQL to label sensitive columns, then configure Advanced Threat Protection to alert only when a SQL injection event is detected against a database with those labels.

Option B is correct because it uses Azure SQL's Data Discovery & Classification to label sensitive columns (e.g., credit card numbers) and then configures Advanced Threat Protection (ATP) to alert only when a SQL injection event is detected against databases with those labels. This approach directly ties the alert trigger to the presence of sensitive data, ensuring alerts are generated only for relevant databases without manual per-database management. It is the most efficient method as it leverages built-in classification and ATP integration, avoiding unnecessary overhead or external dependencies.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
Enable a custom alert rule in Microsoft Sentinel that queries Azure SQL audit logs and filters based on database classification tags.
Why it's wrong here
This is complex and less efficient; Defender for Cloud provides built-in capabilities that integrate with data classification.
✓
Use Data Discovery & Classification in Azure SQL to label sensitive columns, then configure Advanced Threat Protection to alert only when a SQL injection event is detected against a database with those labels.
Why this is correct
Correct. SQL ATP can be linked with data classification to focus alerts on databases containing sensitive data, reducing noise.
Related concept
Read the scenario before looking for a memorised answer.
✗
Disable Advanced Threat Protection for all databases except those that contain sensitive data by manually enabling ATP per database.
Why it's wrong here
Incorrect. While possible, this is not scalable and requires manual maintenance as databases are added or classification changes.
✗
Create a workflow automation in Defender for Cloud that filters SQL injection alerts based on database name.
Why it's wrong here
Incorrect. Workflow automation runs after an alert is generated; it does not prevent alerts on non-sensitive databases.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often assume that manually enabling/disabling ATP per database (Option C) is the simplest approach, overlooking the built-in classification-based filtering that provides automated, scalable, and precise alert targeting without administrative overhead.

Detailed technical explanation

How to think about this question

Azure SQL's Data Discovery & Classification uses a built-in vulnerability assessment to scan for sensitive data patterns (e.g., credit card numbers via regex) and applies persistent classification labels at the column level. Advanced Threat Protection (ATP) for Azure SQL can then be configured to evaluate SQL injection events against these labels using the 'Alert on databases with classification labels' setting, which triggers alerts only when the target database has at least one classified column. This integration works at the database engine level, ensuring low-latency, native filtering without requiring external log ingestion or custom logic.

KKey Concepts to Remember

Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.

TExam Day Tips

Watch for words such as best, first, most likely and least administrative effort.
Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related SC-200 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Manage a security operations environment practice questions

Practise SC-200 questions linked to Manage a security operations environment.

Respond to security incidents practice questions

Practise SC-200 questions linked to Respond to security incidents.

Perform threat hunting practice questions

Practise SC-200 questions linked to Perform threat hunting.

Mitigate threats using Microsoft Defender XDR practice questions

Practise SC-200 questions linked to Mitigate threats using Microsoft Defender XDR.

Mitigate threats using Microsoft Defender for Cloud practice questions

Practise SC-200 questions linked to Mitigate threats using Microsoft Defender for Cloud.

Mitigate threats using Microsoft Sentinel practice questions

Practise SC-200 questions linked to Mitigate threats using Microsoft Sentinel.

SC-200 fundamentals practice questions

Practise SC-200 questions linked to SC-200 fundamentals.

SC-200 scenario practice questions

Practise SC-200 questions linked to SC-200 scenario.

SC-200 troubleshooting practice questions

Practise SC-200 questions linked to SC-200 troubleshooting.

Practice this exam

Start a free SC-200 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

SC-200 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this SC-200 question test?

Mitigate threats using Microsoft Defender for Cloud — This question tests Mitigate threats using Microsoft Defender for Cloud — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Use Data Discovery & Classification in Azure SQL to label sensitive columns, then configure Advanced Threat Protection to alert only when a SQL injection event is detected against a database with those labels. — Option B is correct because it uses Azure SQL's Data Discovery & Classification to label sensitive columns (e.g., credit card numbers) and then configures Advanced Threat Protection (ATP) to alert only when a SQL injection event is detected against databases with those labels. This approach directly ties the alert trigger to the presence of sensitive data, ensuring alerts are generated only for relevant databases without manual per-database management. It is the most efficient method as it leverages built-in classification and ATP integration, avoiding unnecessary overhead or external dependencies.

What should I do if I get this SC-200 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

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 →

How Courseiva writes practice questions · Editorial policy

Keep practising

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.

Loading comments…

This SC-200 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 SC-200 exam.