Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk

Bytes spilled to remote storage in query profile indicates volume of data spilled to remote disk
A . TRUE
B. FALSE

View Answer

Answer: A

Explanation:

This question may come in various format in the exam, so let us not mug it up. Let us understand what it means.

When you run large aggregations, sorts in snowflake the processing usually happens in memory of the virtual warehouse. But if the virtual warehouse is not properly sized and if it does not have enough memory, the intermediate results starts spilling to remote disk(in AWS, it will be S3). When this happens, it impacts the query performance because now you are retrieving your results from remote disk instead of memory. In most of these cases, if it is a regular occurrence you may need to move to a bigger warehouse.

Also read this section referred in the link

https://docs.snowflake.com/en/user-guide/ui-query-profile.html#queries-too-large-to-fit-in-memory