Kusto Query Language (KQL) is the correct choice because Microsoft Defender XDR relies on KQL for all advanced hunting and custom detection rules, enabling you to join the DeviceProcessEvents and DeviceNetworkEvents tables to correlate a process like wscript.exe launching from a user’s temp directory with a subsequent network connection to an external IP. On the MS-102 exam, this scenario tests your understanding of how to build a detection rule that chains process creation events with network events, often appearing as a question where you must select the appropriate query language from options like PowerShell, SQL, or KQL—a common trap is confusing KQL with PowerShell’s syntax for log queries. Remember that KQL is purpose-built for time-series and event correlation in Microsoft’s security stack, so if you need to filter by directory path and then check for outbound connections, KQL’s `| where` and `| join` operators are your tools. A helpful memory tip: KQL stands for “Kusto Query Language,” and you can think of it as the “K” in “hunting” because it’s the key to linking process launches with network activity in Defender XDR.
MS-102 Practice Question: Manage security and threats by using Microsoft Defender XDR
This MS-102 practice question tests your understanding of manage security and threats by using microsoft defender xdr. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. 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 operations team uses Microsoft Defender XDR. They want to create a custom detection rule that alerts when a specific process (e.g., wscript.exe) launches from a user's temp directory and then performs a network connection to an external IP. Which advanced hunting query language should they use?
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Kusto Query Language (KQL)
Microsoft Defender XDR uses Kusto Query Language (KQL) for advanced hunting queries, including custom detection rules. KQL allows querying the DeviceProcessEvents and DeviceNetworkEvents tables to correlate process launches with network connections, making it the correct choice for this scenario.
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.
✓
Kusto Query Language (KQL)
Why this is correct
KQL is the query language used in Microsoft Defender XDR advanced hunting to create custom detection rules.
Related concept
Read the scenario before looking for a memorised answer.
✗
PowerShell
Why it's wrong here
PowerShell is a scripting language but not directly used for advanced hunting queries in Defender XDR.
✗
Splunk SPL
Why it's wrong here
Splunk SPL is used in Splunk, not Microsoft Defender XDR.
✗
SQL
Why it's wrong here
SQL is not supported for advanced hunting in Defender XDR; KQL is the standard query language.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may confuse the query language used in Microsoft Defender XDR with other common tools like PowerShell or SQL, but Microsoft specifically designed KQL for its security analytics and it is the only language supported for custom detections in this context.
Detailed technical explanation
How to think about this question
KQL queries in Defender XDR can join tables like DeviceProcessEvents (for process creation events) with DeviceNetworkEvents (for outbound connections) using the DeviceId and Timestamp fields. A custom detection rule would use a query such as `DeviceProcessEvents | where FileName == "wscript.exe" and FolderPath contains "\\Temp\\" | join DeviceNetworkEvents on DeviceId | where RemoteIPType == "Public"` to trigger alerts. This approach leverages the schema's built-in time-window join capabilities to correlate events within a specified timeframe.
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 healthcare organisation deploys an application with a public-facing web tier and a private database tier. The database subnet has no public IP and only accepts connections from the web tier's security group. Questions like this test whether you can design cloud network isolation using VNets/VPCs, subnets, and security group rules.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this MS-102 question in full detail.
Manage security and threats by using Microsoft Defender XDR — This question tests Manage security and threats by using Microsoft Defender XDR — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Kusto Query Language (KQL) — Microsoft Defender XDR uses Kusto Query Language (KQL) for advanced hunting queries, including custom detection rules. KQL allows querying the DeviceProcessEvents and DeviceNetworkEvents tables to correlate process launches with network connections, making it the correct choice for this scenario.
What should I do if I get this MS-102 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 →
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.
This MS-102 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 MS-102 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.