Question 550
A supported aggregation over one base table is requested repeatedly and needs maintained precalculation. What object fits?
Explanation
Correct Answer
Correct: materialized precomputation. Materialized view maintains a supported precomputed query result for faster consumption.
Incorrect Answers
Not best here: Stream records an offset of changed rows in supported source objects; the case calls for materialized precomputation.
Not best here: Task orchestrates SQL execution on a schedule or predecessor event; the case calls for materialized precomputation.
Not best here: Dynamic table automatically refreshes a materialized transformation result toward a target freshness; the case calls for materialized precomputation.