Question 400
A Snowflake administrator investigates the following production situation: A business query needs the ten newest transactions but sorts the entire customer history after transforming the timestamp to a string. Which test outcome is the strongest acceptance evidence?
Explanation
Correct Answer
This verifies top-k ordering because the query does unnecessary ordering work and can lose proper timestamp ordering. The corresponding corrective action is: Use a typed timestamp ORDER BY with a suitable LIMIT on the required filtered rows. A green status for a different component would not independently establish this result.
Incorrect Answers
Selective point lookups have poor access-path selectivity under the current table layout. “Evaluate Snowflake Search Optimization Service for the supported lookup predicate” would address that alternative cause, not the condition in this question: the query does unnecessary ordering work and can lose proper timestamp ordering.
“Evaluate Query Acceleration Service eligibility and benchmarks for the outlier workload” responds to this separate finding: sporadic eligible query work may benefit from delegated acceleration instead of constant larger compute. This question instead needs “Use a typed timestamp ORDER BY with a suitable LIMIT on the required filtered rows”, so the alternative does not meet the stated condition.
The warehouse's local data cache was cleared during suspension. “Compare cold and warm executions and adjust idle settings only if benefit justifies cost” applies to that separate problem. The observed case is a business query needs the ten newest transactions but sorts the entire customer history after transforming the timestamp to a string; choosing this alternative would address the wrong failure mode.