What is a limitation of a Materialized View?

The correct answer is D. A Materialized View cannot be defined with a JOIN. Snowflake Materialized Views have several documented limitations, and one of the most significant is that they cannot be defined using a JOIN (D). A materialized view's defining query must reference only a single base table. This restriction exists because Snowflake must…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AA Materialized View cannot support any aggregate functions
BA Materialized View can only reference up to two tables
CA Materialized View cannot be joined with other tables
DA Materialized View cannot be defined with a JOIN

How the community answered

(26 responses)

A
8% (2)
B
4% (1)
D
88% (23)

Explanation

Snowflake Materialized Views have several documented limitations, and one of the most significant is that they cannot be defined using a JOIN (D). A materialized view's defining query must reference only a single base table. This restriction exists because Snowflake must automatically maintain the materialized view's pre-computed results as the underlying data changes; tracking incremental changes across joined tables is computationally complex. The other options are incorrect: materialized views do support certain aggregate functions like MIN, MAX, SUM, COUNT, and AVG (A is false); there is no two-table restriction since joins are simply not allowed at all (B is false); and materialized views can freely be joined with other tables in subsequent queries (C is false).

Topics

#Materialized Views#Snowflake Features#Limitations#Data Optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice