Community Q&A

SC-200 — frequently asked questions

Community-vetted answers to 73 common questions about this exam, each traced back to a specific practice question.

Questions from real practice questions

Each Q&A comes from a specific question — follow the link for the full analysis

Creating Custom Tracked Queries in Microsoft Defender

What is the difference between Advanced Hunting and Threat Analytics?

Advanced Hunting is for manual, ad-hoc investigation using KQL. Threat Analytics is for saving and automating those queries as 'trackers' to continuously monitor for threats.

Can I run a custom query without creating a tracker?

Yes, you can run any KQL query in Advanced Hunting. However, only by saving it as a tracker in Threat Analytics does it become a persistent assessment tool for the subscription's status.

How Do You Add a Defender for Cloud Apps Alert to a Sentinel Incident?

Why is the Timeline tab on the Sentinel incidents page not the right option?

The supported preview workflow is not a standalone incident Timeline tab; it starts from the investigation graph, where you select an entity and open the Timeline card in the entity side panel.

Can I add the Defender for Cloud Apps alert from the Microsoft 365 Defender Alerts page?

The Defender portal can show the alert, but the requirement is to update the Microsoft Sentinel incident; that is done from the Sentinel entity timeline, not the Defender Alerts page.

How Do You Run a KQL Query as a Sentinel Search Job?

Does a Microsoft Sentinel search job require a new destination table name?

Yes. The search job writes results to a table, so in the Run a search job pane you specify the new table name before starting the job.

What is the difference between enabling Search job mode and selecting Run a search job?

Enabling Search job mode configures the query for long-running search-job behavior, while selecting Run a search job submits the configured job after the table name is entered.

How to Identify MITRE ATT&CK Phases in Microsoft Sentinel?

Why is the Hunting node not the right choice for MITRE ATT&CK phases?

The Hunting node is for running advanced hunting queries and bookmarks; it does not present the dedicated MITRE ATT&CK coverage matrix that Threat management provides.

Does the Incidents node show attacker tactics and techniques?

Incidents group alerts for triage, but the dedicated MITRE ATT&CK node is the view that maps detections to tactics and techniques with minimal effort.

How do you join two Sentinel auxiliary tables for six months of data?

Why can't I JOIN Table1 and Table2 directly in Workspace1?

Auxiliary tables in Microsoft Sentinel only support single-table queries, so JOIN and similar cross-table operators fail until search jobs stage the data into Analytics tables.

Should I delete the _SRCH tables after joining Table1 and Table2?

Yes. The _SRCH tables are temporary search-job outputs; deleting them after the JOIN minimizes storage and retention costs, which the question requires.

How do you check if AzureActivity exists in each Sentinel workspace?

How do I return a row when AzureActivity does not exist in one of my Sentinel workspaces?

Use union isfuzzy=true together with a datatable(isMissing:int)[1] seed row so the query never fails and always emits exactly one row with isMissing set to 0 or 1.

Why does a plain union break a multi-workspace Sentinel workbook query?

A plain union resolves every table reference up front, so if AzureActivity is absent in one workspace the whole query errors instead of reporting isMissing = 1.

Which least-privilege role enables the Microsoft Sentinel plugin in Copilot for Security?

Why doesn't Security Copilot Contributor alone allow the Sentinel plugin to work?

Copilot Contributor authorizes Copilot use, but Sentinel data access is controlled by Sentinel workspace RBAC, so User1 still needs a Sentinel role.

Why is Microsoft Sentinel Contributor not the least-privilege choice?

It grants write and management actions, while the plugin scenario only needs read/query access; Microsoft Sentinel Reader is narrower.

What retention period should you set for the AzureActivity table?

Why not set AzureActivity retention to 30 days to save costs?

30 days is the default but does not maximize interactive queries; Azure Activity data is free to retain for 90 days, so 90 days gives more query time at no extra retention cost.

What happens to AzureActivity data after 90 days?

It is deleted unless you extend retention or use long-term retention, which adds cost and is not needed to meet the minimize-cost requirement.

Which Devices Support Custom IoCs in Defender for Endpoint?

Why can't Device4 use custom IoCs in Defender for Endpoint?

Device4 does not satisfy the platform or onboarding requirements for Defender for Endpoint custom indicators, so custom IoCs are not applied to it.

Do custom IoCs require onboarding in Defender for Endpoint?

Yes. Custom indicators are enforced on devices that are onboarded to Defender for Endpoint and running a supported operating system.

How should a scheduled KQL job write to an existing Sentinel data lake table?

Why doesn't assigning Microsoft Sentinel Reader to Job1's managed identity solve this?

It grants read access to Workspace1 data, but the question's issue is writing Job1 output into existing Table1, which requires matching Table1's schema.

Does appending _KQL_CL_ to Table1 fix the scheduled KQL job?

No, the table already exists and the suffix is not a mechanism for aligning Job1's output columns and types.

Which KQL Table and Status Code Show Unauthorized Requests?

Why is AzureActivity not the table for this SC-200 KQL hotspot?

AzureActivity records Azure control-plane operations and lacks ResponseStatusCode; MicrosoftGraphActivityLogs stores Graph API HTTP status codes, so it is the correct table.

Does insufficient authorization mean 401 or 403 in MicrosoftGraphActivityLogs?

This hotspot targets 401 Unauthorized, which Graph activity logs capture for requests rejected as unauthorized; 403 Forbidden represents a separate permissions condition.

Where to Create a Conditional Access App Control Custom Policy and Enable It

Can I create the Custom1 Conditional Access App Control policy directly in the Entra admin center?

No. Entra Conditional Access only hosts the Session control and a 'Configure custom policy' link; the session policy itself must be authored in the Microsoft Defender portal under Cloud apps > Policies.

Which Policy1 setting references the Custom1 session policy?

The Session access controls. Enable 'Use Conditional Access App Control' there and pick Custom1 as the custom policy to apply to the session.

Escalating Alerts in Azure Sentinel via Incident Assignment

Why is sharing the URL not the best answer?

Sharing a URL is a passive action that doesn't notify the other administrator or update the incident's ownership status, which can lead to tracking issues.

Can I assign multiple incidents at once?

Yes, you can select multiple incidents in the incident list view and use the 'Assign' action to delegate them to one or more administrators simultaneously.

How do you enable Sentinel UEBA and collect on-premises AD DS events?

Why can't Windows Event Forwarding and the Windows Forwarded Events connector enable UEBA for AD DS?

WEF only ships security event logs; it does not sync Active Directory users, groups or other directory entities. UEBA needs identity entities, which come from the Defender for Identity connector.

Must the Defender for Identity sensor be installed before configuring the connector in Sentinel1?

Yes. The connector authenticates to your Defender for Identity instance and pulls its data, so the sensor must already be running on a domain controller and reporting identity data.

Configuring Automated Investigation Packages in Microsoft Defender for Endpoint

What is an Investigation Package in Microsoft Defender for Endpoint?

An Investigation Package is a compressed ZIP file containing forensic data collected by MDE during an automated investigation. It includes details like running processes, network connections, and registry changes to help analysts understand the threat context.

Can Microsoft Sentinel Automation Rules collect investigation packages directly?

No. Sentinel Automation Rules manage incident states and notifications. To collect an investigation package via Sentinel, you would need to create a custom playbook (Logic App) that calls the MDE API, which adds significant administrative complexity.

Collecting Forensic Data in Microsoft Defender XDR

What does an Investigation Package include?

It collects running processes, active network connections, installed programs, scheduled tasks, services, and relevant event logs from the endpoint.

When should I use Live Response instead?

Use Live Response when you need to perform specific, ad-hoc commands or interact with the system in real-time to investigate complex, non-standard scenarios.

Suppressing False Positive Alerts in Microsoft Defender for Endpoint

Why is resolving the alert not the correct answer?

Resolving an alert keeps it visible in the Alerts queue with a 'Resolved' status. The question requires hiding the alert, which removes it from the queue entirely.

Can suppression rules be scoped to device groups?

Yes, modern Microsoft Defender for Endpoint allows suppression rules to be scoped to specific device groups, making it ideal for targeting specific teams like accounting.

Microsoft Defender for Identity Honeytoken Configuration

What are Honeytoken entities in Microsoft Defender for Identity?

Honeytokens are decoy accounts or devices with no legitimate use. Any activity involving them triggers an alert, helping detect attacker movement.

Where do I configure Honeytokens in the MDI portal?

Navigate to Settings > Identities > Entity tags > Honey Token to add Users or Devices as traps for malicious actors.

Can I use Azure AD Identity Protection to create MDI honeytokens?

No. Azure AD Identity Protection manages cloud identity risks and conditional access, while MDI honeytokens are configured specifically within the Defender for Identity platform.

Least-privilege roles for Microsoft 365 Defender action approvals

Does Security Reader allow approving Defender for Endpoint actions?

No. Security Reader grants read-only access to security information; approving or rejecting MDE remediation actions requires the Active remediation actions role (or a broader admin role such as Security Administrator).

Why isn't Security Administrator the least-privilege answer?

It can approve actions, but it also permits policy updates, alert dismissal and other tenant-wide security administration, which exceeds an analyst's approve/reject requirement.

What if the analyst only needs to view pending actions?

Then Security Reader alone is sufficient for read-only access, but the scenario requires approve and reject, so B is also needed.

Enforcing MFA for Remote Workers Using Named Locations

Can I use IP addresses instead of country names in Named Locations?

Yes, Named Locations support both IPv4/IPv6 address ranges and country codes. For a single office, defining the specific IP range is often more precise than using the country.

What happens if a remote worker uses a VPN to spoof the office IP?

If the VPN terminates within the trusted IP range, the Named Location will still consider it trusted. To prevent this, you should combine Named Locations with other conditions like device compliance or block known VPN services.

Identifying Zero-Hour Auto Purge (ZAP) Actions in Defender

Is ZAP activity logged in the Exchange mailbox audit log?

No. Microsoft explicitly states that Zero-Hour Auto Purge (ZAP) actions are not recorded as system actions in the Exchange mailbox audit logs.

Where can I see detailed ZAP events for a specific email?

You can use Threat Explorer in Microsoft Defender for Office 365, filtering by 'All email events' and checking the 'Additional action' column for 'ZAP'.

Detect Data Theft by Departing Users with Insider Risk Management

Can Defender for Cloud Apps monitor departing users?

Defender for Cloud Apps primarily focuses on active user sessions and real-time anomaly detection. For comprehensive analysis of departing user behavior and historical data exfiltration patterns, Insider Risk Management is the recommended tool.

What is the difference between Insider Risk Policy and File Policy?

A File Policy in Defender for Cloud Apps monitors file access and sharing in real-time for active users. An Insider Risk Policy analyzes user behavior over time to assign risk scores, specifically targeting high-risk behaviors like data theft by employees who are leaving the organization.

Supported File Formats for Microsoft Security Copilot Uploads

What file formats are supported for uploading to Microsoft Security Copilot?

Microsoft Security Copilot supports common text-based file formats including DOCX, PDF, TXT, and MD for uploading documents to provide context.

Are there size limits for files uploaded to Security Copilot?

Yes, individual files must not exceed 3 MB, and the total size of uploaded files cannot exceed 20 MB.

Querying Sentinel Watchlists via Azure Resource Graph

Can I query watchlist data in a Sentinel workbook?

Yes, but you must use the 'Logs (Analytics)' data source to query the actual data stored in the watchlist. To list the watchlist resources themselves, you must use Azure Resource Graph.

What KQL query lists Sentinel watchlists?

You query the SecurityInsightsWatchlist resource type using Azure Resource Graph: search type == SecurityInsightsWatchlist.

Validate ASR Policy Impact Using Troubleshooting Mode

What is the difference between Troubleshooting mode and Selective isolation?

Troubleshooting mode temporarily bypasses security controls like ASR rules for diagnostics. Selective isolation restricts network access but does not bypass execution policies.

Can I use PowerShell to validate ASR blocks instead of Troubleshooting mode?

While you can use PowerShell to check logs or adjust settings, Troubleshooting mode is the designated, low-effort diagnostic tool within the Defender portal for this specific scenario.

Manual Remediation for Malware-Infected Emails in Defender XDR

Can AIR hard delete emails?

While newer versions of AIR have expanded capabilities, in the context of this exam question, hard deletion is distinguished from soft deletion as a potentially manual step to avoid accidental data loss, whereas soft deletion is the standard automated remediation.

Does MDE full automation include device isolation?

Yes, Microsoft Defender for Endpoint's full automation settings include automatic isolation of devices when high-confidence malware is detected, removing the need for manual analyst intervention.

What is the difference between isolating and containing a device?

In the context of Defender for Endpoint, both terms generally refer to restricting network access to protect the rest of the environment. Both can be automated under full automation settings.

Minimize Administrative Effort for Process and Network Data in Microsoft Defender

Why is 'Collect an investigation package' better than 'Live Response'?

An investigation package automatically gathers relevant forensic data, including process and network information, into a ZIP file without requiring manual command execution or real-time terminal interaction.

What does the investigation package contain?

It typically includes system inventory, process information, network connections, and other security-relevant events, packaged for easy review after extraction.

Creating a Custom Promptbook in Microsoft Security Copilot

Where should I start when creating a custom promptbook?

You must start in the Security Copilot standalone portal, not the Microsoft Defender XDR portal. The standalone interface is where promptbooks are managed and built.

Why do I need to enter prompts before creating the promptbook?

Entering prompts allows Copilot to generate the necessary context and history. You must test the prompts on a sample incident to ensure they work before selecting them for inclusion in the book.

Responding to Compromised Linux Endpoints in Microsoft Defender XDR

Can I isolate a Linux device in Microsoft Defender for Endpoint?

Yes, Microsoft Defender for Endpoint supports isolating Linux devices from the network. This allows you to contain threats while maintaining a management connection.

What is the difference between 'Contain user' and 'Isolate device'?

'Contain user' blocks the user's ability to sign in or access resources based on their identity. 'Isolate device' blocks the specific machine's network traffic, preventing it from communicating with other endpoints or servers.

Defender for Cloud Alert JSON: Finding Privilege Escalation Tactic

Which Defender for Cloud alert JSON key holds the MITRE ATT&CK tactic?

The top-level intent property. In the REST alert schema, intent carries values such as Execution or PrivilegeEscalation, which map to MITRE ATT&CK tactics.

Can extendedProperties contain MITRE ATT&CK details in Defender for Cloud alerts?

Yes, some alert types may include product-specific MITRE metadata in extendedProperties, but it is not the canonical field for the alert's tactic. Use intent for consistent filtering and treat extendedProperties as an optional fallback.

How does the search change in Microsoft Sentinel?

Sentinel's SecurityAlert table exposes Tactics and Techniques as separate columns; intent is specific to the raw Defender for Cloud alert payload. Normalize accordingly before writing analytics rules.

Sentinel custom parser: remove the hardcoded TimeGenerated filter

Why does a Microsoft Sentinel custom parser need no TimeGenerated filter?

The query that calls the parser supplies the time range. A hardcoded where TimeGenerated > ago(...) would force every caller into that relative window and prevent arbitrary historical searches.

Is removing line 5's sort also required before creating Parser1?

Sorting is unnecessary and often removed for performance and reusability, but it is not the defining parser constraint tested here. The first required edit is the hardcoded time filter on line 2.

Can I use !contains in a Microsoft Sentinel parser?

Yes, string operators are allowed if they express the parsing or filtering logic. Replacing !contains with !has changes semantics and should depend on whether you need substring matching or term matching, not on parser creation.

Defender for Endpoint File Hash Indicators: PE Files Only

Can Microsoft Defender for Endpoint block a PDF or Office file by using a file-hash indicator?

No. File indicators support portable executable (PE) files, so File2.pdf, File3.docx, and File4.xlsx are outside that scope; use other controls for non-PE content.

Why is File1.sys blockable when the documentation examples mention .exe and .dll?

A .sys driver is a PE-format file. In the SC-200 scenario, it is treated as supported by file indicators, while PDF and Office documents are not.

Does 'Block and remediate' allow blocking any file hash?

It is not the same as a preconfigured file indicator. 'Block and remediate' is an incident response action; file-indicator creation is limited to supported PE file types.

Microsoft Graph activity log KQL for DELETE requests

Why does the query use matches regex on RequestUri rather than contains?

The URI must match a structured /users/{GUID} pattern; a loose substring operator would also match unrelated paths and would not isolate the trailing user ID reliably.

Which column is split to extract the deleted user ID, and why?

RequestUri is split on / and the last segment is taken because the deleted user's object ID appears at the end of the Graph request path.

Why filter ResponseStatusCode to 204 in the MicrosoftGraphActivityLogs query?

A successful Microsoft Graph DELETE returns 204 No Content, so the filter excludes failed or non-deletion attempts and keeps completed deletion requests.