Snowflake COF-R02 Question Answer
What is a limitation of a Materialized View?
A Materialized View cannot support any aggregate functions
A Materialized View can only reference up to two tables
A Materialized View cannot be joined with other tables
A Materialized View cannot be defined with a JOIN
There are several limitations to using materialized views:
A materialized view can query only a single table.
Joins, including self-joins, are not supported.
TESTED 02 Aug 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved