Crucial Exams

Microsoft Security Operations Analyst Associate SC-200 Practice Question

You are investigating potential data exfiltration performed by WinRAR. In Microsoft Defender XDR advanced hunting, you must retrieve events where WinRAR created an archive in a user profile folder and subsequently opened an outbound HTTPS connection from the same process instance. Which KQL approach should you use to correlate the two tables and return only matching rows?

  • Use union to combine DeviceProcessEvents and DeviceNetworkEvents, then filter for WinRAR and port 443.

  • Use join kind=leftanti between DeviceProcessEvents and DeviceNetworkEvents to identify WinRAR processes without matching network activity.

  • Use join kind=inner between DeviceProcessEvents (ProcessId) and DeviceNetworkEvents (InitiatingProcessId) on DeviceId so only rows that exist in both tables are returned.

  • Use summarize arg_max() across both tables grouped by DeviceId to merge the latest process and network events.

Microsoft Security Operations Analyst Associate SC-200
Manage security threats
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot