For producing intermediate summary records which component is to be used?
-
Scan
-
Sort
-
Rollup
-
Aggregate
A
Correct answer
Explanation
Scan is used to produce intermediate summary records because it can read all input records and generate summary output without requiring grouping or aggregation logic. Sort is for ordering, Rollup is for grouped summaries, and Aggregate is for similar grouped operations - Scan is the appropriate choice for simple intermediate summaries.