SnowPro Core Certification — Question 167

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

Answer options

• A. Whether or not it is also a secure view
• B. How often the underlying base table is queried
• C. How often the base table changes
• D. Whether the materialized view has a cluster key defined
• E. How often the materialized view is queried

Correct answer: C, D

Explanation

The credit consumption for maintaining a materialized view is primarily influenced by how often the base table changes (C) and whether a cluster key is defined (D). Other options like query frequency do not directly impact the maintenance costs in terms of credits.