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.

Correct Option - c

To get all Infosys Certified Snowflake Advanced Developer Exam questions Join Group https://bit.ly/infy_premium_group

We're passionate about offering best placement materials and courses!! A one stop place for Placement Materials. We daily post Offcampus updates and Placement Materials.

Qtr No. 213, New Town Yehlanka Indore 454775

admin@prepflix.in