Question 1
While validating a Snowflake workload, engineers observe: Hundreds of short BI queries queue on a busy warehouse even though each individual query is fast when it starts. Which test outcome is the strongest acceptance evidence?
Explanation
Correct Answer
This verifies scale out concurrent users because the warehouse lacks enough concurrent cluster capacity for peak users. The corresponding corrective action is: Evaluate a multi-cluster warehouse under the supported edition and scaling policies. A green status for a different component would not independently establish this result.
Incorrect Answers
Changes to underlying data can invalidate eligibility for persisted result reuse. “Treat result-cache eligibility as conditional and remeasure execution after data changes” would address that alternative cause, not the condition in this question: the warehouse lacks enough concurrent cluster capacity for peak users.
“Review the service-specific billing and scheduling controls rather than relying only on warehouse suspension” responds to this separate finding: serverless services can consume managed compute independently of a user warehouse. This question instead needs “Evaluate a multi-cluster warehouse under the supported edition and scaling policies”, so the alternative does not meet the stated condition.
The workload lacks sufficient memory and compute for individual query execution. “Benchmark a larger warehouse size and compare runtime and credit use for the query” applies to that separate problem. The observed case is hundreds of short BI queries queue on a busy warehouse even though each individual query is fast when it starts; choosing this alternative would address the wrong failure mode.