View all questions & answers for the COF-C02 exam
What impacts the credit consumption of maintaining a materialized view? (Choose two.)
Whether or not it is also a secure view
How often the underlying base table is queried
How often the base table changes
Whether the materialized view has a cluster key defined
How often the materialized view is queried
The credit consumption for maintaining a materialized view is impacted by how often the base table changes © and whether the materialized view has a cluster key defined (D). Changes to the base table can trigger a refresh of the materialized view, consuming credits. Additionally, having a cluster key defined can optimize the performance and credit usage during the materialized view’s maintenance. References: SnowPro Core Certification materialized view credit consumption
Submit