Intermediate
Big Data & Data Engineering
Q67 / 100
What is a "materialized view" in a data warehouse, and why use one?
Correct! Well done.
Incorrect.
The correct answer is A) A precomputed query result stored physically, refreshed periodically, to speed up repeated complex queries
A
Correct Answer
A precomputed query result stored physically, refreshed periodically, to speed up repeated complex queries
Explanation
Materialized views cache the results of expensive queries on disk, trading storage and refresh overhead for much faster read performance on repeated queries.
Progress
67/100