Question 90
A test plan evaluates: A table is manually partitioned into separate daily physical files to achieve traditional partition maintenance in regular Snowflake tables. Which evidence should be required before release?
Explanation
Correct Answer
Time-filtered SQL queries prune eligible partitions without user-maintained folder partition definitions. This validates the relevant action: Rely on Snowflake-managed micro-partitions and design predicates or clustering strategy appropriately. The underlying Snowflake behavior is: Standard Snowflake tables automatically organize data into micro-partitions rather than requiring manual file partitions.
Incorrect Answers
The selected retention setting is accepted without unsupported edition assumptions. This evidence tests a DIFFERENT situation: A team increases Time Travel retention to 90 days on a Standard Edition account without checking edition limits. The correction required in this case is: Rely on Snowflake-managed micro-partitions and design predicates or clustering strategy appropriately.
The chosen permanent table has documented Fail-safe coverage while transient test tables do not. This evidence tests a DIFFERENT situation: A staging team creates transient tables for reproducible data but expects the seven-day Fail-safe recovery of permanent tables. The correction required in this case is: Rely on Snowflake-managed micro-partitions and design predicates or clustering strategy appropriately.
The reporting warehouse completes the sample dashboard while cloud services metadata operations remain unaffected. This evidence tests a DIFFERENT situation: A reporting dashboard slows during warehouse saturation, and an analyst proposes resizing cloud services instead of compute. The correction required in this case is: Rely on Snowflake-managed micro-partitions and design predicates or clustering strategy appropriately.