Answer-first summary for fast verification
Answer: A Materialized View cannot be defined with a JOIN
The correct answer is D because Snowflake documentation explicitly states that materialized views cannot be defined with JOIN clauses, including self-joins. This is a fundamental limitation of materialized views in Snowflake. Option A is incorrect because materialized views do support some aggregate functions (with restrictions). Option B is incorrect because materialized views can only reference a single table, not two tables. Option C is incorrect because materialized views can be joined with other tables in queries, even though they cannot contain JOINs in their definition. The community discussion strongly supports D with 100% consensus and references to official documentation confirming this limitation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is a limitation of a Materialized View?
A
A Materialized View cannot support any aggregate functions
B
A Materialized View can only reference up to two tables
C
A Materialized View cannot be joined with other tables
D
A Materialized View cannot be defined with a JOIN