- A
EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on NetworkMessageId | where Url == 'https://malicious.com'
This query correctly joins on NetworkMessageId, filters delivered emails, and then filters for the specific URL.
- B
EmailEvents | where DeliveryAction != 'Blocked' | join kind=leftouter EmailUrlInfo on NetworkMessageId | where Url == 'https://malicious.com'
Why wrong: Left outer join would include emails with no URL match, potentially returning nulls; an inner join is more appropriate.
- C
EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on Name | where Url == 'https://malicious.com'
Why wrong: The correct join key is NetworkMessageId, not Name.
- D
EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on SenderFromDomain | where Url == 'https://malicious.com'
Why wrong: Joining on SenderFromDomain would produce incorrect associations; NetworkMessageId is the unique message identifier.
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. A key principle to apply: networkMessageId is the primary join key for email-related tables in Advanced Hunting.. 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 using Microsoft 365 Defender advanced hunting to investigate a phishing campaign. The analyst wants to find emails that were delivered to users (DeliveryAction != 'Blocked') and contained a specific malicious URL (e.g., 'https://malicious.com'). The EmailEvents table contains delivery information, and the EmailUrlInfo table contains URL details. Which KQL query correctly joins these two tables to find the desired emails?
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
EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on NetworkMessageId | where Url == 'https://malicious.com'
Option A is correct because it uses an inner join on the `NetworkMessageId` column, which is the common key between `EmailEvents` and `EmailUrlInfo` tables in Microsoft 365 Defender advanced hunting. The query first filters `EmailEvents` to only delivered emails (`DeliveryAction != 'Blocked'`), then joins with `EmailUrlInfo` to match URLs to those emails, and finally filters for the specific malicious URL. This ensures only emails that were delivered and contained the target URL are returned.
Key principle: NetworkMessageId is the primary join key for email-related tables in Advanced Hunting.
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 | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on NetworkMessageId | where Url == 'https://malicious.com'
Why this is correct
This query correctly joins on NetworkMessageId, filters delivered emails, and then filters for the specific URL.
Related concept
NetworkMessageId is the primary join key for email-related tables in Advanced Hunting.
- ✗
EmailEvents | where DeliveryAction != 'Blocked' | join kind=leftouter EmailUrlInfo on NetworkMessageId | where Url == 'https://malicious.com'
Why it's wrong here
Left outer join would include emails with no URL match, potentially returning nulls; an inner join is more appropriate.
- ✗
EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on Name | where Url == 'https://malicious.com'
Why it's wrong here
The correct join key is NetworkMessageId, not Name.
- ✗
EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on SenderFromDomain | where Url == 'https://malicious.com'
Why it's wrong here
Joining on SenderFromDomain would produce incorrect associations; NetworkMessageId is the unique message identifier.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates may choose a `leftouter` join (Option B) thinking it is safer to include all delivered emails, but the requirement is to find only emails that actually contained the malicious URL, making an `inner` join the correct choice.
Detailed technical explanation
How to think about this question
In Microsoft 365 Defender advanced hunting, `EmailEvents` and `EmailUrlInfo` are related via the `NetworkMessageId` column, which uniquely identifies each email message. The `inner` join ensures only rows with matching `NetworkMessageId` in both tables are returned, which is critical for accurately associating URLs with their parent emails. A real-world scenario is investigating a phishing campaign where the attacker uses multiple URLs; joining on `NetworkMessageId` allows the analyst to pivot from a known malicious URL to all affected mailboxes without false positives from unrelated emails.
KKey Concepts to Remember
- NetworkMessageId is the primary join key for email-related tables in Advanced Hunting.
- An `inner join` returns only rows with matching values in both tables.
- The `EmailEvents` table contains email delivery actions and message metadata.
- The `EmailUrlInfo` table details URLs extracted from emails.
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
NetworkMessageId is the primary join key for email-related tables in Advanced Hunting.
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.
What to study next
Got this wrong? Here's your next step.
Review networkMessageId is the primary join key for email-related tables in Advanced Hunting., then practise related SC-200 questions on the same topic to reinforce the concept.
- →
Mitigate threats using Microsoft Defender XDR — study guide chapter
Learn the concepts, then practise the questions
- →
Mitigate threats using Microsoft Defender XDR practice questions
Targeted practice on this topic area only
- →
All SC-200 questions
1,639 questions across all exam domains
- →
Microsoft Security Operations Analyst SC-200 study guide
Full concept coverage aligned to exam objectives
- →
SC-200 practice test guide
How to use practice tests most effectively before exam day
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.
Manage a security operations environment practice questions
Practise SC-200 questions linked to Manage a security operations environment.
Respond to security incidents practice questions
Practise SC-200 questions linked to Respond to security incidents.
Perform threat hunting practice questions
Practise SC-200 questions linked to Perform threat hunting.
Mitigate threats using Microsoft Defender XDR practice questions
Practise SC-200 questions linked to Mitigate threats using Microsoft Defender XDR.
Mitigate threats using Microsoft Defender for Cloud practice questions
Practise SC-200 questions linked to Mitigate threats using Microsoft Defender for Cloud.
Mitigate threats using Microsoft Sentinel practice questions
Practise SC-200 questions linked to Mitigate threats using Microsoft Sentinel.
SC-200 fundamentals practice questions
Practise SC-200 questions linked to SC-200 fundamentals.
SC-200 scenario practice questions
Practise SC-200 questions linked to SC-200 scenario.
SC-200 troubleshooting practice questions
Practise SC-200 questions linked to SC-200 troubleshooting.
Practice this exam
Start a free SC-200 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this SC-200 question test?
Mitigate threats using Microsoft Defender XDR — This question tests Mitigate threats using Microsoft Defender XDR — NetworkMessageId is the primary join key for email-related tables in Advanced Hunting..
What is the correct answer to this question?
The correct answer is: EmailEvents | where DeliveryAction != 'Blocked' | join kind=inner EmailUrlInfo on NetworkMessageId | where Url == 'https://malicious.com' — Option A is correct because it uses an inner join on the `NetworkMessageId` column, which is the common key between `EmailEvents` and `EmailUrlInfo` tables in Microsoft 365 Defender advanced hunting. The query first filters `EmailEvents` to only delivered emails (`DeliveryAction != 'Blocked'`), then joins with `EmailUrlInfo` to match URLs to those emails, and finally filters for the specific malicious URL. This ensures only emails that were delivered and contained the target URL are returned.
What should I do if I get this SC-200 question wrong?
Review networkMessageId is the primary join key for email-related tables in Advanced Hunting., then practise related SC-200 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
NetworkMessageId is the primary join key for email-related tables in Advanced Hunting.
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 →
Last reviewed: Jun 11, 2026
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.