The correct tables are EmailAttachmentInfo, DeviceProcessEvents, and DeviceNetworkEvents. This is because the email attachment to process to network chain requires tracking the specific file that was attached to the email, the process it spawned, and the outbound connection it made—EmailAttachmentInfo links the email to the file, DeviceProcessEvents captures the PowerShell execution, and DeviceNetworkEvents logs the connection to the malicious IP. On the MS-102 exam, this tests your ability to map a multi-stage attack across different data sources in Advanced Hunting, a common scenario for custom detection rules. A frequent trap is choosing EmailEvents instead of EmailAttachmentInfo, but EmailEvents lacks the file-level details needed to tie the attachment to the process. Remember the chain: file, process, network—think “FPN” for File, Process, Network to recall the three tables in order.
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. A key principle to apply: advanced Hunting uses KQL for querying security data.. 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 is creating a custom detection rule in Microsoft 365 Defender Advanced Hunting. The rule should detect when a user opens a malicious email attachment, which launches a PowerShell process, and then that PowerShell process makes an outbound connection to a known malicious IP address. Which three Advanced Hunting tables must be joined in the KQL query?
EmailAttachmentInfo provides the attachment details, DeviceProcessEvents captures the PowerShell launch, and DeviceNetworkEvents captures the network connection.
Option B is correct because the detection requires tracking the attachment that initiated the process (EmailAttachmentInfo), the PowerShell process execution (DeviceProcessEvents), and the outbound network connection to a malicious IP (DeviceNetworkEvents). EmailAttachmentInfo provides the link between the email and the file, while EmailEvents lacks file-level details needed for this chain.
Key principle: Advanced Hunting uses KQL for querying security data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
EmailAttachmentInfo provides the attachment details, DeviceProcessEvents captures the PowerShell launch, and DeviceNetworkEvents captures the network connection.
Related concept
Advanced Hunting uses KQL for querying security data.
DeviceLogonEvents tracks user logons, which is not part of the required detection sequence.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often choose EmailEvents (Option A) thinking it captures attachment details, but EmailEvents lacks the file hash and name fields needed to join to process events, while EmailAttachmentInfo is the correct table for attachment-to-process correlation.
Detailed technical explanation
How to think about this question
Under the hood, Advanced Hunting tables are optimized for specific data types: EmailAttachmentInfo stores the SHA256 hash and file name of attachments, which can be joined to DeviceProcessEvents via the SHA256 hash to trace process creation from a malicious file. DeviceNetworkEvents includes RemoteIP, RemotePort, and protocol fields (e.g., TCP), enabling detection of outbound connections to known malicious IPs. In a real-world scenario, a phishing email with a malicious .docm file spawns PowerShell via a macro; the SHA256 hash in EmailAttachmentInfo links to the process in DeviceProcessEvents, and the process's DeviceId and Timestamp join to DeviceNetworkEvents to identify the C2 connection.
KKey Concepts to Remember
Advanced Hunting uses KQL for querying security data.
EmailAttachmentInfo provides details on email attachments.
DeviceProcessEvents tracks process creation and execution.
DeviceNetworkEvents logs outbound and inbound network connections.
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
Advanced Hunting uses KQL for querying security data.
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 — Advanced Hunting uses KQL for querying security data..
What is the correct answer to this question?
The correct answer is: EmailEvents, DeviceProcessEvents, DeviceNetworkEvents — Option B is correct because the detection requires tracking the attachment that initiated the process (EmailAttachmentInfo), the PowerShell process execution (DeviceProcessEvents), and the outbound network connection to a malicious IP (DeviceNetworkEvents). EmailAttachmentInfo provides the link between the email and the file, while EmailEvents lacks file-level details needed for this chain.
What should I do if I get this MS-102 question wrong?
Review advanced Hunting uses KQL for querying security data., then practise related MS-102 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
Advanced Hunting uses KQL for querying security data.
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.