Question 540
One large query spills to local storage due to limited memory, without other queries queued. What change should be evaluated?
Explanation
Correct Answer
Correct: scale-up resources for one execution. Warehouse resize adds compute capability to a single warehouse cluster.
Incorrect Answers
Not best here: Multi-cluster warehouse scales concurrent work by providing additional clusters; the case calls for scale-up resources for one execution.
Not best here: Query Acceleration Service can offload eligible query processing to separate serverless resources; the case calls for scale-up resources for one execution.
Not best here: AUTO_SUSPEND halts warehouse compute after the defined idle interval; the case calls for scale-up resources for one execution.