What is a characteristic of materialized views in Snowflake?

The correct answer is C. Multiple tables can be joined in the underlying query of a materialized view. Based on updated Snowflake capabilities, materialized views can include joins across multiple tables in their defining query (C). Option A ('do not allow joins') reflects an older limitation that has since been relaxed in newer Snowflake releases. Option B is incorrect because…

Data Transformations

Question

Options

AMaterialized views do not allow joins.
BClones of materialized views can be created directly by the user.
CMultiple tables can be joined in the underlying query of a materialized view.
DAggregate functions can be used as window functions in materialized views.

How the community answered

(23 responses)

A
4% (1)
C
91% (21)
D
4% (1)

Explanation

Based on updated Snowflake capabilities, materialized views can include joins across multiple tables in their defining query (C). Option A ('do not allow joins') reflects an older limitation that has since been relaxed in newer Snowflake releases. Option B is incorrect because materialized views cannot be cloned directly by the user - cloning a schema or database that contains a materialized view does not clone the MV itself. Option D is incorrect because window functions (analytic functions using OVER()) are not supported in materialized view definitions; only aggregate functions in non-window contexts are permitted.

Topics

#Materialized Views#Data Transformations#Query Optimization

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice