Question 10
A test plan evaluates: A table scan touches most rows even though a predicate selects one month, and clustering metadata shows overlapping date ranges. Which evidence should be required before release?
Explanation
Correct Answer
A targeted query scans fewer partitions after an appropriate data organization correction. This validates the relevant action: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning. The underlying Snowflake behavior is: Micro-partition metadata enables pruning when values allow partitions to be excluded from the scan.
Incorrect Answers
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: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.
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: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.
A test query resolves the intended object using the documented naming convention. This evidence tests a DIFFERENT situation: An ETL engineer uses unquoted mixed-case identifiers and expects exact case-sensitive behavior across sessions. The correction required in this case is: Use Query Profile and clustering information to assess whether physical micro-partition organization supports pruning.