SnowPro Core Certification — Question 681

What is a characteristic of materialized views in Snowflake?

Answer options

• A. Materialized views do not allow joins.
• B. Clones of materialized views can be created directly by the user.
• C. Multiple tables can be joined in the underlying query of a materialized view.
• D. Aggregate functions can be used as window functions in materialized views.

Correct answer: A

Explanation

The correct answer is A because materialized views in Snowflake indeed do not support joins, which makes them different from regular views. Options B and C are incorrect as they misrepresent the capabilities of materialized views, while option D inaccurately describes the use of aggregate functions within them.