Question 780
A summary table used for alerts is being recreated by a large on-demand query for every analyst. Which response best meets the security operations requirement?
Explanation
Correct Answer
Materialized aggregates prevent repeated heavy computation. This directly addresses the requirement to prefer available summary signals to repeated scans.
Incorrect Answers
Selective inputs reduce join expansion and execution cost. This addresses optimize expensive lake joins; it does not directly satisfy prefer available summary signals to repeated scans.
Expired or moved source data cannot be recovered by query syntax alone. Its intended use is to assess retention before blaming KQL logic, whereas this case requires the analyst to prefer available summary signals to repeated scans.
Narrow source and time boundaries reduce unnecessary scans. That action focuses on reduce hunting query resource use rather than the specified need to prefer available summary signals to repeated scans.






Microsoft Security Operations Analyst (SC-200) Practice Tests