The correct table to query is EmailEvents, because it stores the essential metadata for every email message processed by Microsoft 365 Defender, including the sender’s address in fields like SenderFromAddress and SenderMailFromAddress. When you need to find emails by sender in advanced hunting, EmailEvents is the only table that directly captures the sender identity along with timestamps and delivery actions, making it the precise source for filtering messages from a specific address over the last 7 days. On the SC-200 exam, this question tests your ability to map a common investigative task—phishing analysis—to the correct advanced hunting schema, and a frequent trap is confusing EmailEvents with EmailAttachmentInfo or EmailUrlInfo, which focus on file or link details rather than the sender. Remember the mnemonic: “Sender search starts with Events” — if you’re hunting for who sent it, think EmailEvents first.
SC-200 Mitigate threats using Microsoft Defender XDR Practice Question
This SC-200 practice question tests your understanding of mitigate threats 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 analyst is investigating a phishing campaign using Microsoft 365 Defender advanced hunting. The analyst needs to find all emails sent from a specific sender address in the last 7 days. Which table should be queried?
Correct. EmailEvents contains sender, recipient, subject, and other email delivery properties. It is the primary table for email metadata.
B
EmailAttachmentInfo
Why wrong: EmailAttachmentInfo contains details about attachments (e.g., file name, hash) but not sender information. It is used in conjunction with EmailEvents.
C
EmailUrlInfo
Why wrong: EmailUrlInfo stores URLs extracted from emails, not sender details. Useful for investigating links, not sender addresses.
D
DeviceEvents
Why wrong: DeviceEvents contains endpoint events (e.g., process, registry, file events) on devices, not email metadata.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
EmailEvents
The EmailEvents table in Microsoft 365 Defender advanced hunting stores metadata about email messages, including sender addresses, recipients, timestamps, and delivery actions. To find all emails from a specific sender in the last 7 days, you query EmailEvents because it contains the 'SenderFromAddress' or 'SenderMailFromAddress' fields needed to filter by sender. The other tables focus on attachments, URLs, or device-level events, which are not relevant for identifying emails by sender address.
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.
✓
EmailEvents
Why this is correct
Correct. EmailEvents contains sender, recipient, subject, and other email delivery properties. It is the primary table for email metadata.
Related concept
Read the scenario before looking for a memorised answer.
✗
EmailAttachmentInfo
Why it's wrong here
EmailAttachmentInfo contains details about attachments (e.g., file name, hash) but not sender information. It is used in conjunction with EmailEvents.
✗
EmailUrlInfo
Why it's wrong here
EmailUrlInfo stores URLs extracted from emails, not sender details. Useful for investigating links, not sender addresses.
✗
DeviceEvents
Why it's wrong here
DeviceEvents contains endpoint events (e.g., process, registry, file events) on devices, not email metadata.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may confuse the purpose of EmailAttachmentInfo or EmailUrlInfo, thinking they contain sender data, when in fact they only store attachment or URL details and require a join with EmailEvents to correlate back to the sender.
Detailed technical explanation
How to think about this question
The EmailEvents table is part of the Email & Collaboration schema in Advanced Hunting and includes columns like 'EmailDirection' (inbound/outbound) and 'DeliveryAction' (e.g., 'Delivered', 'Junked'), which allow analysts to filter by sender and delivery status simultaneously. Under the hood, this table is populated from Exchange Online transport logs, capturing SMTP envelope data (MAIL FROM) and header from addresses (From:), enabling precise sender-based queries. A real-world scenario is investigating a targeted phishing campaign where the attacker uses a spoofed sender address; querying EmailEvents with a time filter and 'SenderFromAddress' helps identify all recipients of the malicious email.
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.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this SC-200 question in full detail.
Mitigate threats using Microsoft Defender XDR — This question tests Mitigate threats 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: EmailEvents — The EmailEvents table in Microsoft 365 Defender advanced hunting stores metadata about email messages, including sender addresses, recipients, timestamps, and delivery actions. To find all emails from a specific sender in the last 7 days, you query EmailEvents because it contains the 'SenderFromAddress' or 'SenderMailFromAddress' fields needed to filter by sender. The other tables focus on attachments, URLs, or device-level events, which are not relevant for identifying emails by sender address.
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 →
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 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.
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.