A Snowflake user has a Snow SQL query that is running for a long time. When the user opens the query profiler, it indicates that a lot of data is spilling to disk.
What is causing this to happen?
The result cache is almost full and is unable to hold the results
The cloud storage staging area is not sufficient to hold the data results.
The warehouse memory is not sufficient to hold the intermediate query results.
Clustering has not been applied to the table so the table is not optimized.
To get all Infosys Certified Snowflake Advanced Developer Exam questions Join Telegram Group https://rebrand.ly/lex-telegram-236dee