Discuss Snowflake COF-C02 Exam Topic 1 Question 70

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

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

Get Premium COF-C02 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

23 comments · newest first

Jesusita 2 days ago

I feel like B is misleading. Two tables isn’t really a hard limit.

Irma 7 days ago

True, but C seems more restrictive overall.

Vesta 12 days ago

But what about A? No aggregate functions is a big deal!

Rosalind 17 days ago

I agree, C makes sense. They can’t join with other tables.

Genevive 22 days ago

I think option C is correct. Materialized Views can be limiting in joins.

Cary 28 days ago

Yeah, I've seen them used with joins before, so this is surprising!

Kiera 1 month ago

Wait, are you sure about that? I thought they could join with other tables.

Mauricio 1 month ago

Definitely can't be defined with a JOIN, that's a limitation.

Loreen 1 month ago

I thought they could reference more than two tables?

Devorah 2 months ago

A Materialized View can support aggregate functions, that's not true.

Raul 2 months ago

Materialized Views are great, but they do have some limitations.

Bernardine 2 months ago

Wait, are you sure about that? I thought JOINs were allowed.

Darell 2 months ago

Totally agree, they can be joined with other tables!

Sylvia 2 months ago

I thought they could reference more than two tables?

Dwight 2 months ago

A Materialized View can definitely use aggregate functions.

Tina 3 months ago

I think D sounds familiar, but I can't quite remember if you can define a materialized view with a JOIN or not.

Buddy 3 months ago

I vaguely recall that materialized views can be joined with other tables, so C might not be correct either.

Mee 3 months ago

I’m not sure about the limit on tables, but I feel like I’ve seen questions about materialized views referencing more than two tables.

William 3 months ago

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

Vallie 3 months ago

I’m confused about D; I thought you could define a materialized view with a JOIN, but I need to double-check that.

Farrah 4 months ago

I practiced a question about joins with materialized views, and I think they can be joined with other tables, so C seems off.

Dean 4 months ago

I’m not entirely sure, but I feel like materialized views can reference more than two tables. Maybe that rules out B?

Carin 5 months ago

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

Snowflake COF-C02 Exam - Topic 1 Question 70 Discussion