Question 530
After the approved change, engineers revisit: An organization enables multiple materialized views for rarely used reports and sees maintenance charges rising above query savings. Which result establishes the intended state?
Explanation
Correct Answer
Net compute and storage costs improve while frequently used reports retain acceptable latency. This validates the relevant action: Measure view refresh cost and query utilization, removing unproductive maintained results. The underlying Snowflake behavior is: Materialized views incur maintenance costs as source data changes even when queries are infrequent.
Incorrect Answers
The dashboard reflects committed updates rather than relying on stale cached output. This evidence tests a DIFFERENT situation: A dashboard runs the same query after base-table data changes and expects the previous persisted result to remain valid. The correction required in this case is: Measure view refresh cost and query utilization, removing unproductive maintained results.
A repeated eligible query reuses its persisted result when result-cache conditions are satisfied. This evidence tests a DIFFERENT situation: A frequently repeated report returns instant results, and its owner claims a warehouse ran and earned cache credit savings each time. The correction required in this case is: Measure view refresh cost and query utilization, removing unproductive maintained results.
Task history shows cleansing begins only after upstream success according to graph semantics. This evidence tests a DIFFERENT situation: A task DAG should perform cleansing only after an ingest task succeeds, but the team schedules both independently at the same minute. The correction required in this case is: Measure view refresh cost and query utilization, removing unproductive maintained results.