Question 1mediummultiple choice
Full question →mediummultiple choiceObjective-mapped
A company has several Azure virtual machines running SQL Server (IaaS). The security team wants to enable Advanced Threat Protection for these SQL Server instances to detect threats like SQL injection. What should they do?
Answer choices
Why each option matters
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
A
Best answer
Deploy the SQL Server IaaS Agent extension on each VM and enable Azure Defender for SQL in Microsoft Defender for Cloud.
Correct. The SQL IaaS Agent extension registers the VM with the SQL resource provider. After that, enabling Azure Defender for SQL (under Defender for Cloud plans) provides Advanced Threat Protection and vulnerability assessment for the SQL Server instances.
B
Distractor review
Enable Azure Defender for Servers on the subscription; it automatically protects SQL Server workloads.
Azure Defender for Servers provides host-level threat detection (e.g., file integrity monitoring, network anomalies) but does not include SQL-specific protections like SQL injection detection. SQL workloads require Azure Defender for SQL.
C
Distractor review
Enable Azure Defender for SQL on the Log Analytics workspace used by the VMs.
Azure Defender for SQL is enabled per subscription or per SQL server resource, not per Log Analytics workspace. The workspace configuration is for data ingestion, not for enabling the Defender plan.
D
Distractor review
Configure the Microsoft Sentinel SQL connector to ingest SQL audit logs.
The SQL connector in Sentinel ingests audit logs for analysis but does not enable the built-in threat detection capabilities of Azure Defender for SQL. The two are separate: Defender generates alerts, Sentinel can ingest them.
Common exam trap
Common exam trap: answer the scenario, not the keyword
Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.
Technical deep dive
How to think about this question
This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.
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.
- Use explanations to understand the rule behind the answer.
TExam Day Tips
- Underline the problem statement mentally.
- 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.
Related practice questions
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.
More questions from this exam
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
A Microsoft Sentinel scheduled analytics rule detects impossible travel but creates too many duplicate incidents for the same user within a short period. Which two rule settings should you tune? (Choose 2.)
Question 2
A phishing email was delivered to several users. The analyst wants to find all messages in the campaign, see delivery actions, and perform remediation from the Microsoft 365 Defender portal. Which tool should they use?
Question 3
A security analyst in Microsoft Defender for Cloud receives an alert that an Azure VM has a vulnerability with a high severity. The analyst wants to see the detailed finding, including the steps to remediate. Which blade or page should the analyst open?
Question 4
A company uses Microsoft Defender for Cloud to protect an Azure Kubernetes Service (AKS) cluster. The security team wants to receive security alerts about suspicious activities within the cluster, such as a container running with root privileges or attempts to read sensitive host paths. Which Defender for Cloud plan must be enabled to generate these alerts?
Question 5
A security analyst is configuring Microsoft Sentinel scheduled analytics rules to detect brute-force attacks on Microsoft Entra ID. Arrange the steps in the correct order from first to last.
Question 6
An organization uses Microsoft 365 Defender. A security analyst is investigating a malware incident on a user's device. The automated investigation and response (AIR) has already isolated the device from the network. The analyst now needs to collect a copy of a specific suspicious file from the device for further analysis. Which action should the analyst initiate from the device's entity page?
FAQ
Questions learners often ask
What does this SC-200 question test?
Read the scenario before looking for a memorised answer.
What is the correct answer to this question?
The correct answer is: Deploy the SQL Server IaaS Agent extension on each VM and enable Azure Defender for SQL in Microsoft Defender for Cloud. — For SQL Server on Azure VMs (IaaS), to enable Advanced Threat Protection and vulnerability assessment, you must first install the SQL Server IaaS Agent extension on each VM. This extension registers the SQL Server instance with the resource provider, enabling management capabilities. Then, you enable Azure Defender for SQL on the subscription (or the SQL server's resource group) from Microsoft Defender for Cloud. Enabling Azure Defender for Servers only provides host-level protections, not SQL-specific threat detection. The SQL connector in Microsoft Sentinel is for log ingestion, not threat detection.
What should I do if I get this SC-200 question wrong?
Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.
Discussion
Loading comments…
Sign in to join the discussion.