Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 683

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Choose two.)

    Correct Answer: A, B

    To determine if a query is too large to fit in memory, you need to look for indications that data is being spilled to storage. 'Bytes spilled to local cache' typically refers to data that does not fit in memory and is temporarily being stored in a cache. 'Bytes spilled to local storage' indicates that data is being written to local disk because it cannot be held in memory. Both of these statistics are strong indicators that the query is exceeding the available memory.

Discussion
Ram9198Options: BD

Bytes are spilled to local disk first , then out of memory goto remote disk

ravuri_rkOptions: BD

https://docs.snowflake.com/en/user-guide/ui-query-profile

MultiCloudIronManOptions: BD

https://www.bing.com/search?q=bytes+spilled+to+local+storage+snowflake&cvid=e844f19876134a32bab1cd2c43995f87&aqs=edge.2.0j69i57j0l7j69i11004.7813j0j9&FORM=ANAB01&PC=U531