What is a limitation of a Materialized View?

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

View Answer

Answer: D

Explanation:

Materialized Views in Snowflake are designed to store the result of a query and can be refreshed to maintain up-to-date data. However, they have certain limitations, one of which is that they cannot be defined using a JOIN clause. This means that a Materialized View can only be created based on a single source table and cannot combine data from multiple tables using JOIN operations.

Reference: Snowflake Documentation on Materialized Views

SnowPro® Core Certification Study Guide