nerdexam
Snowflake

COF-R02 · Question #246

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

The correct answer is D. Whether the materialized view has a cluster key defined E. How often the materialized view is queried. See the full explanation below for the reasoning.

Question

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

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

(52 responses)
  • A
    17% (9)
  • B
    2% (1)
  • C
    6% (3)
  • D
    75% (39)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice