Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A user observes that a query in Snowflake is experiencing prolonged execution time. The query profile indicates significant data spilling to local disk.
What is the most likely cause of this performance issue?
A
The result cache is almost full and is unable to hold the results.
B
The cloud storage staging area is not sufficient to hold the data results.
C
Clustering has not been applied to the table so the table is not optimized.
D
The warehouse memory is not sufficient to hold the intermediate query results.
