Snowflake COF-C02 Exam - Topic 1 Question 70 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 70
Topic #: 1

[All COF-C02 Questions]

What is a limitation of a Materialized View?

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

Show Suggested Answer

Suggested Answer: D

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.

References:

Snowflake Documentation on Materialized Views

SnowPro Core Certification Study Guide

by Genevieve at May 14, 2026, 03:26 AM

Limited Time Offer

25%

Off

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Carin

21 days ago

I think I remember that materialized views can actually support aggregate functions, so A might be wrong.

upvoted 0 times

...