Answer-first summary for fast verification
Answer: A materialized view can query only a single table., Data accessed through materialized views can be stale.
Option A is correct because Snowflake materialized views can only query a single base table and cannot include joins, aggregations, or multiple tables, as confirmed by the official documentation and community consensus. Option B is also correct because materialized views can contain stale data between automatic refreshes, especially if the underlying table changes frequently. Option C is incorrect because Snowflake automatically maintains materialized view refreshes in Enterprise edition and above, not requiring user intervention. Option D is incorrect because materialized views are designed to improve query performance by pre-computing results, making queries against them typically faster than against base tables.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which statement accurately describes a characteristic of a materialized view?
A
A materialized view can query only a single table.
B
Data accessed through materialized views can be stale.
C
Materialized view refreshes need to be maintained by the user.
D
Querying a materialized view is slower than executing a query against the base table of the view.
No comments yet.