Your team maintains a Microsoft Defender XDR custom detection rule whose Advanced Hunting query joins the endpoint and identity tables. You also ingest a verbose custom application log into a dedicated custom table in your Microsoft Sentinel workspace, and an engineer proposes extending the same custom detection rule's query to reference that Sentinel custom table so a single rule covers both data sets. Why will referencing that Microsoft Sentinel custom table inside a Microsoft Defender XDR custom detection rule fail to work as proposed?
- AA Microsoft Defender XDR custom detection rule can query Microsoft Sentinel custom tables, but only after the workspace is upgraded to the unified data lake tier for cross-product queries.
- BA Microsoft Defender XDR custom detection rule can reference any table, but a custom table breaks alert deduplication because Sentinel custom tables never contain a ReportId column.
- CA Microsoft Defender XDR custom detection rule cannot use a query that joins more than two tables, so adding the Sentinel custom table exceeds the join limit the rule allows.
- DA Microsoft Defender XDR custom detection rule runs only over the Microsoft Defender XDR Advanced Hunting schema, so a Microsoft Sentinel workspace custom table is not available to its query. Correct
Why A is wrong: Tempting because the data lake does broaden query reach, but a custom detection rule still binds to the XDR schema; no tier upgrade exposes a Sentinel custom table to it.
Why B is wrong: Tempting because ReportId matters for deduplication, but the genuine reason is scope: the rule cannot see the Sentinel custom table at all, not merely that one column is absent.
Why C is wrong: Tempting because complex joins feel risky, but there is no two-table join cap on custom detection rules; the blocker is that the Sentinel custom table is outside the XDR Advanced Hunting schema.
Why D is correct: Correct: custom detection rules execute against the XDR Advanced Hunting tables, which do not include arbitrary Microsoft Sentinel workspace custom tables, so the proposed reference cannot resolve.