Skip to content

SC-200 · Domain 3: Perform threat hunting · 22% of the exam

Task 3.2: Detect threats by using the Microsoft Sentinel platform

Hunting queries and hunts, KQL jobs in the data lake, summary rule tables, and notebooks with the Sentinel MCP server.

Study it

  • Hunting queries, hunts and bookmarks in Sentinel

    Lesson coming

  • KQL jobs and summary rules in the data lake

    Lesson coming

  • Data lake notebooks and the Sentinel MCP server

    Partly covered by: Agents and Tools, The Tool-Use Loop

Sample questions

Try each one before opening the answer. Every option is explained, with the Microsoft documentation page that proves it.

Question 1 · choose 1

A KQL job should promote 90 days of filtered sign-in data from the data lake into a new table in the analytics tier of the SOC workspace. You hold Security Operator in Microsoft Entra ID. The job fails when it tries to create the table. What fixes it?

  1. AWrite the results to a federated table instead
  2. BAssign Log Analytics Contributor on the workspace to the data lake managed identity
  3. CAdd the _CL suffix to the table name yourself
  4. DSchedule the job to start at least 30 minutes after creation so the table exists first
Show the answer and why
  • AWrite the results to a federated table instead

    Incorrect

    Jobs can't write to federated tables.

  • BAssign Log Analytics Contributor on the workspace to the data lake managed identity

    Correct

    Creating new custom tables in the analytics tier needs this role for the msg-resources managed identity.

  • CAdd the _CL suffix to the table name yourself

    Incorrect

    The service adds _KQL_CL to tables the job creates.

  • DSchedule the job to start at least 30 minutes after creation so the table exists first

    Incorrect

    The start-time rule applies to scheduled jobs, not to table creation.

KQL jobs can promote lake data to the analytics tier. To create new custom tables there, assign the Log Analytics Contributor role on the workspace to the data lake's managed identity (msg-resources-<guid>). Tables created by a job get the _KQL_CL suffix, and jobs can't write to federated tables.

Question 2 · choose 1

A Sentinel workspace that isn't onboarded to the data lake stores firewall flow logs in an Auxiliary table. Analysts need per-source-IP counts refreshed every 30 minutes in an analytics table for detections. Which feature fits?

  1. AA KQL job scheduled every 30 minutes
  2. BA search job each half hour
  3. CAn NRT analytics rule on the Auxiliary table
  4. DA summary rule that writes to a custom analytics table
Show the answer and why
  • AA KQL job scheduled every 30 minutes

    Incorrect

    KQL jobs need the data lake onboarding that this workspace lacks.

  • BA search job each half hour

    Incorrect

    Search jobs are one-time, long-running searches of a single table.

  • CAn NRT analytics rule on the Auxiliary table

    Incorrect

    Real-time rules don't run on low-cost tiers.

  • DA summary rule that writes to a custom analytics table

    Correct

    Summary rules aggregate Auxiliary or Basic data on a 20-minute to 24-hour schedule.

Summary rules run frequent aggregations in the background and store results in analytics-tier custom tables. They're the choice when data is in a workspace that isn't onboarded to the data lake, for example in Auxiliary or Basic tiers, and when you need frequent summaries.

Question 3 · choose 1

Your workspace was onboarded to the Sentinel data lake in June. An investigation needs SecurityEvent records from long-term retention covering March, which predates onboarding. Which tool do you use to pull them into a table for analysis?

  1. AA KQL job over the lake for March
  2. BRestore on the data lake tier
  3. CA search job on the SecurityEvent table
  4. DA summary rule with a 90-day lookback
Show the answer and why
  • AA KQL job over the lake for March

    Incorrect

    KQL jobs serve data from the onboarding date onward.

  • BRestore on the data lake tier

    Incorrect

    Restore isn't available for data lake tier data.

  • CA search job on the SecurityEvent table

    Correct

    Search jobs reach archived data older than the onboarding date.

  • DA summary rule with a 90-day lookback

    Incorrect

    Summary rules look back at most one day.

If you're onboarded to the Microsoft Sentinel data lake, use search jobs to access archived data older than your onboarding date, and KQL jobs for data from the onboarding date onward. A search job scans a single table and writes results to a new analytics table.

Question 4 · choose 1

After onboarding to the Defender portal, a hunter runs a query in advanced hunting and wants to bookmark three suspicious rows with notes and entity mappings, as they did in Sentinel. The option isn't there. Where do they create the bookmarks?

  1. AMicrosoft Sentinel > Threat management > Hunting
  2. BAdvanced hunting, after enabling guided mode
  3. CThe Action center, from the query results
  4. DA custom detection that saves the rows
Show the answer and why
  • AMicrosoft Sentinel > Threat management > Hunting

    Correct

    Bookmarks are still available in the Sentinel-specific hunting experience.

  • BAdvanced hunting, after enabling guided mode

    Incorrect

    Bookmarks aren't available in advanced hunting in either mode.

  • CThe Action center, from the query results

    Incorrect

    The Action center tracks remediation actions.

  • DA custom detection that saves the rows

    Incorrect

    Detections create alerts, not bookmarks with notes.

Bookmarks aren't available in advanced hunting, the unified query experience across Defender and Sentinel data. They remain in Microsoft Sentinel > Threat management > Hunting, where results can be bookmarked with notes, entity and MITRE ATT&CK mappings and escalated to incidents.

Question 5 · choose 1

A hunter adds the Sentinel MCP data exploration collection to Visual Studio Code. The tenant is onboarded to the Sentinel data lake, but the hunter can't list any of the collection's tools, including the table search and query tools that don't use Security Copilot. What's the hunter most likely missing?

  1. AA Security Copilot SCU allocation
  2. BThe Security reader role
  3. CA self-hosted MCP server in Azure
  4. DMicrosoft Sentinel Playbook Operator
Show the answer and why
  • AA Security Copilot SCU allocation

    Incorrect

    SCUs are consumed only by specific tools, such as the entity analyzer; they don't gate listing the collection's tools.

  • BThe Security reader role

    Correct

    Listing and invoking Sentinel's MCP tools needs Security reader.

  • CA self-hosted MCP server in Azure

    Incorrect

    The server is fully hosted; nothing is deployed.

  • DMicrosoft Sentinel Playbook Operator

    Incorrect

    Playbook roles don't grant MCP tool access.

Microsoft Sentinel's MCP server is hosted and uses Microsoft Entra for identity. Most tools require data lake onboarding, some also need Sentinel in the Defender portal, Defender XDR or Security Copilot, and users need the Security reader role to list and invoke the tools.

Question 6 · choose 2

A hunter builds a PySpark notebook in the Microsoft Sentinel extension for Visual Studio Code that scores risky sign-ins from lake data. The scores must land in a custom lake table every night without anyone running the notebook. Which two pieces do this? (Choose TWO.)

  1. ARun the notebook from the classic Sentinel notebooks blade instead
  2. BRun the notebook from advanced hunting
  3. CPaste the Python cells into a KQL job
  4. DWrite the results with MicrosoftSentinelProvider.save_as_table()
  5. ESchedule the notebook as a notebook job
Show the answer and why
  • ARun the notebook from the classic Sentinel notebooks blade instead

    Incorrect

    That's a different experience from data lake notebooks, without these jobs.

  • BRun the notebook from advanced hunting

    Incorrect

    Advanced hunting runs KQL queries, not notebooks.

  • CPaste the Python cells into a KQL job

    Incorrect

    KQL jobs run KQL queries only.

  • DWrite the results with MicrosoftSentinelProvider.save_as_table()

    Correct

    The provider class writes the results to custom tables.

  • ESchedule the notebook as a notebook job

    Correct

    Notebook jobs run notebooks on a schedule and write results to tables.

Data lake notebooks come from the Microsoft Sentinel extension for Visual Studio Code and run PySpark on Spark compute. The MicrosoftSentinelProvider class's save_as_table() function writes or appends results to custom tables, and notebook jobs run the notebook on a schedule.

Question 7 · choose 1

On the Microsoft Sentinel Hunting page, you sort queries by Results delta to spot spikes. What does Results delta compare?

  1. AYour results with other Sentinel customers' results
  2. BResults this week with last week
  3. CResults in the last 24 hours with the previous 24 to 48 hours
  4. DQuery results with analytics rule alerts
Show the answer and why
  • AYour results with other Sentinel customers' results

    Incorrect

    Results come only from your workspace.

  • BResults this week with last week

    Incorrect

    The comparison windows are 24 hours long.

  • CResults in the last 24 hours with the previous 24 to 48 hours

    Correct

    Results delta compares the last 24 hours against the previous 24-48 hours.

  • DQuery results with analytics rule alerts

    Incorrect

    It compares a query's own results over time.

Results delta and Results delta percentage compare a hunting query's results in the last 24 hours with the previous 24-48 hours, highlighting large differences in volume.

Question 8 · choose 1

A hunter used Microsoft Sentinel livestream sessions to watch for an attacker's tools during an active incident. That option is gone. What does Microsoft suggest instead to keep running the query and notify the team?

  1. AKeep the hunting query as a favorite so it reruns every minute
  2. BKQL jobs, analytics rules or playbooks
  3. CBookmarks on each result
  4. DA workbook with auto refresh
Show the answer and why
  • AKeep the hunting query as a favorite so it reruns every minute

    Incorrect

    Favorites run when the Hunting page opens, not on a schedule.

  • BKQL jobs, analytics rules or playbooks

    Correct

    They're the stated alternatives, with persistent results and notifications.

  • CBookmarks on each result

    Incorrect

    Bookmarks preserve rows; they don't run queries.

  • DA workbook with auto refresh

    Incorrect

    Workbooks visualize data; they don't notify anyone.

Microsoft Sentinel livestreams are no longer available. To automate queries and notifications, use KQL jobs, analytics rules or playbooks, which offer persistent query results and support messaging platforms.

Question 9 · choose 1

On the Microsoft Sentinel Hunting page, the Queries tab lists the hunting queries installed from Content hub solutions. How are they grouped?

  1. ABy MITRE ATT&CK tactic
  2. BBy data connector
  3. CBy the analyst who created them
  4. DBy incident severity
Show the answer and why
  • ABy MITRE ATT&CK tactic

    Correct

    All hunting queries on the Queries tab are grouped by MITRE ATT&CK tactics.

  • BBy data connector

    Incorrect

    You can filter by data source, but grouping is by tactic.

  • CBy the analyst who created them

    Incorrect

    Authorship isn't the grouping.

  • DBy incident severity

    Incorrect

    Hunting queries aren't tied to incident severity.

The Queries tab lists the hunting queries installed with Content hub solutions and any you created. Queries are grouped by their MITRE ATT&CK tactics, and you can sort and filter by data source, tactic, technique, results and results delta.

Question 10 · choose 1

You want an AI agent to prioritize open incidents and run hunts over your organization's data through the Sentinel MCP server. Which tool collection do you connect?

  1. AData exploration
  2. BSecurity Copilot agent creation
  3. CGraph builder
  4. DTriage
Show the answer and why
  • AData exploration

    Incorrect

    It's for exploring tables and lake data.

  • BSecurity Copilot agent creation

    Incorrect

    It builds Security Copilot agents.

  • CGraph builder

    Incorrect

    There's no MCP collection by that name.

  • DTriage

    Correct

    The triage collection is for triaging incidents and hunting.

Sentinel's MCP server offers the Data exploration, Security Copilot agent creation and Triage collections. Triage integrates AI models with APIs that support incident triage and hunting.

Practise domain 3 →Practise all domains →