Question 310
During a Snowflake architecture review, the team finds: After a large UPDATE on a native table, storage usage temporarily grows and an operator expects old compressed partitions to be edited in place. Which corrective action best addresses the stated problem?
Explanation
Correct Answer
The root issue is that Snowflake creates new micro-partitions for changed data while older versions may remain for retention. The selected fix targets that condition: Assess changed-partition volume and retention settings instead of expecting in-place page updates. Validate it by checking this outcome: The UPDATE result is correct and storage history explains retained older partition versions.
Incorrect Answers
This action targets durable shared storage, where Snowflake managed table storage is separate from the lifecycle of a particular warehouse. In the given incident, the decisive issue is instead that Snowflake creates new micro-partitions for changed data while older versions may remain for retention.
This action targets cloud services metadata, where metadata services maintain object definitions and privileges separately from raw table scans. The corrective response here is “Assess changed-partition volume and retention settings instead of expecting in-place page updates”; this alternative does not provide that response.
This action targets cluster depth observation, where related key ranges overlap broadly across micro-partitions and reduce pruning efficiency. The stem reports after a large UPDATE on a native table, storage usage temporarily grows and an operator expects old compressed partitions to be edited in place; this control addresses a different failure condition.