Microsoft Security Operations Analyst Associate SC-200 Practice Question
You are writing a custom hunting query in Microsoft Defender XDR. You need to find PowerShell command events that downloaded content from an external URL during the last 24 hours and produce a list showing each DeviceId with the number of such events. Which KQL snippet meets the requirement?
DeviceNetworkEvents | where Timestamp > ago(24h) | where FileName endswith ".ps1" | summarize count() by DeviceId
DeviceNetworkEvents | where Timestamp > ago(24h) | where ActionType == "powershell-command" and RemoteUrl !startswith "http://internal" | summarize DeviceId by count()
DeviceNetworkEvents | where Timestamp > ago(24h) | where ActionType == "powershell-command" and RemoteUrl !startswith "http://internal" | project DeviceId, count()
DeviceNetworkEvents | where Timestamp > ago(24h) | where ActionType == "powershell-command" and RemoteUrl !startswith "http://internal" | summarize Events = count() by DeviceId
The query must first narrow the result set to the previous 24 hours, then filter for the relevant PowerShell command action and exclude internal URLs. To return a per-device count, the summarize operator must be used with count() and grouped by DeviceId. The first choice meets all these requirements. The second choice filters on file extension instead of the action type and URL. The third choice projects fields without aggregating, so it does not produce counts. The fourth choice places the arguments to summarize in the wrong order, which is invalid KQL syntax.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is KQL and how is it used in Microsoft Defender XDR?
Open an interactive chat with Bash
Why is the summarize operator important in hunting queries?
Open an interactive chat with Bash
What does 'RemoteUrl !startswith "http://internal"' achieve in the query?
Open an interactive chat with Bash
Microsoft Security Operations Analyst Associate SC-200
Manage security threats
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .