Snowflake Exam COF-C02 Topic 7 Question 35 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 35
Topic #: 7

[All COF-C02 Questions]

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

AWhether or not it is also a secure view

BHow often the underlying base table is queried

CHow often the base table changes

DWhether the materialized view has a cluster key defined

EHow often the materialized view is queried

Show Suggested Answer

Suggested Answer: A

by Bettina at Jun 28, 2024, 08:50 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

3 days ago

I believe the credit consumption is also affected by how often the underlying base table changes.

upvoted 0 times

...

4 days ago

I agree with Allene. The frequency of querying the materialized view definitely plays a role.

upvoted 0 times

...

10 days ago

I think the credit consumption is impacted by how often the materialized view is queried.

upvoted 0 times

...