SnowPro Core Certification — Question 164

What is a limitation of a Materialized View?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D because a Materialized View cannot be created using a JOIN clause in its definition. Options A, B, and C are incorrect as Materialized Views can support aggregate functions, can reference more than two tables, and can be joined with other tables in queries, despite having limitations on their own definition.