easyMultiple ChoiceObjective-mapped
SC-200 Practice Question: A security analyst wants to identify all devices…
A security analyst wants to identify all devices in the organization that have a specific software vulnerability (CVE-2023-1234) installed using Microsoft 365 Defender Advanced Hunting. Which table should be queried?
⚠ Common exam trap
Candidates often confuse DeviceTvmSoftwareInventory (which lists installed software) with DeviceTvmSoftwareVulnerabilities (which lists actual vulnerabilities), leading them to pick Option C because they think software inventory implies vulnerability presence.
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
✓
DeviceTvmSoftwareVulnerabilities
The DeviceTvmSoftwareVulnerabilities table in Microsoft 365 Defender Advanced Hunting contains records of software vulnerabilities discovered on devices, including specific CVE identifiers like CVE-2023-1234. This table is designed to answer questions about which devices have a particular vulnerability installed, as it links device IDs to vulnerability details such as CVE ID, severity, and exploitability.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
DeviceInfo
Why it's wrong here
DeviceInfo stores device metadata like operating system, device name, domain, and onboarding state; it is a device facts table, not a findings table. It lacks any CVE-specific or vulnerability-status columns, so you cannot directly identify devices with a particular CVE from it. It could only be used as a join target after the vulnerable devices are already identified.
- ✓
DeviceTvmSoftwareVulnerabilities
Why this is correct
DeviceTvmSoftwareVulnerabilities is the Threat & Vulnerability Management (TVM) table containing one row for each software vulnerability detected on a device, with fields such as CveId, DeviceId, SoftwareVendor, SoftwareName, SoftwareVersion, and exploitability/severity information. Filtering on a specific CveId returns every affected device, which is exactly the required result. This makes it the canonical and correct data source for the analyst's query.
- ✗
DeviceTvmSoftwareInventory
Why it's wrong here
DeviceTvmSoftwareInventory records the software packages installed on each device, including vendor, name, and version, but it is purely an inventory table and does not contain CVE identifiers or vulnerability findings. Having a software title and version does not tell you whether a specific CVE affects that device; that requires a correlation with vulnerability intelligence. So on its own, this table cannot answer which devices have a specific CVE.
- ✗
DeviceNetworkInfo
Why it's wrong here
DeviceNetworkInfo provides network-related details such as IP and MAC addresses, network interfaces, and connection states, and it is focused on device connectivity and topology rather than security findings. It has no columns for CVEs, vulnerability severity, or patch status. Therefore it is completely unrelated to identifying devices exposed to a given software vulnerability.
Go deeper
Related to this question
About these practice questions
This SC-200 question is part of Courseiva's 209-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
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.