Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A query in Snowflake executed for 40 minutes, and the profile output shows a high value for 'Bytes spilled to local storage'. What is the root cause of this performance issue, and what are the recommended steps to resolve it?
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.
