Explanation:
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.
Ultimate access to all questions.
No comments yet.
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.