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

The correct answer is C. How often the base table changes D. Whether the materialized view has a cluster key defined. 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…

Performance Management

Question

Options

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

How the community answered

(37 responses)

A
11% (4)
B
5% (2)
C
76% (28)
E
8% (3)

Explanation

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

Topics

#Materialized Views#Credit Consumption#Maintenance Costs#Clustering

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice