Answer-first summary for fast verification
Answer: Materialized views do not allow joins.
The correct answer is A because Snowflake documentation explicitly states that materialized views can only query a single table and do not support joins, including self-joins. This is confirmed by multiple community comments with high upvotes (8 upvotes for vinny2020's comment) that reference the official documentation. Option C is incorrect because materialized views cannot join multiple tables. Option B is incorrect because while clones can be created, they are not directly created by users but through the CREATE CLONE command. Option D is incorrect because while aggregate functions can be used in materialized views, the question specifically asks about characteristics, and the join limitation is the most fundamental characteristic mentioned in the documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a characteristic of a materialized view in Snowflake?
A
Materialized views do not allow joins.
B
Clones of materialized views can be created directly by the user.
C
Multiple tables can be joined in the underlying query of a materialized view.
D
Aggregate functions can be used as window functions in materialized views.
No comments yet.