Question 730
A KQL job performs a large multi-table join without filtering either input by the suspected indicator. Which action most directly addresses the observed condition?
Explanation
Correct Answer
Selective inputs reduce join expansion and execution cost. This directly addresses the requirement to optimize expensive lake joins.
Incorrect Answers
Narrow source and time boundaries reduce unnecessary scans. This addresses reduce hunting query resource use; it does not directly satisfy optimize expensive lake joins.
Materialized aggregates prevent repeated heavy computation. That action focuses on prefer available summary signals to repeated scans rather than the specified need to optimize expensive lake joins.
Expired or moved source data cannot be recovered by query syntax alone. This addresses assess retention before blaming KQL logic; it does not directly satisfy optimize expensive lake joins.






Microsoft Security Operations Analyst (SC-200) Practice Tests