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
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
Latest COF-C02 Dumps Valid Version with 254 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund