SnowPro Core Certification — Question 459

A Snowflake query took 40 minutes to run. The results indicate that ‘Bytes spilled to local storage’ was a large number.

What is the issue and how can it be resolved?

Answer options

• A. The warehouse is too large. Decrease the size of the warehouse to reduce the spillage.
• B. The warehouse is too small. Increase the size of the warehouse to reduce the spillage.
• C. The Snowflake console has timed-out. Contact Snowflake Support.
• D. The warehouse consists of a single cluster. Use a multi-cluster warehouse to reduce the spillage.

Correct answer: B

Explanation

The correct answer is B because a large amount of 'Bytes spilled to local storage' typically indicates that the warehouse does not have sufficient resources to handle the query efficiently, thus requiring an increase in size. Option A is incorrect since reducing the warehouse size would exacerbate the spillage issue. Options C and D do not address the core problem related to resource allocation for the query.