
Answer-first summary for fast verification
Answer: How often the base table changes, Whether the materialized view has a cluster key defined
The correct answers are C and D. According to Snowflake documentation and the community consensus (with CD receiving 96% support), credit consumption for maintaining materialized views is primarily influenced by: (C) How often the base table changes - each change triggers background maintenance that consumes compute resources, and (D) Whether the materialized view has a cluster key defined - maintaining clustering adds additional costs. Option E (how often the materialized view is queried) is incorrect because querying doesn't impact maintenance costs; it only affects query execution costs. Option B (how often the underlying base table is queried) is irrelevant to maintenance costs. Option A (whether it's a secure view) doesn't affect maintenance credit consumption.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What factors influence the credit usage for maintaining a materialized view? (Select two.)
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
No comments yet.