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

Which statistics are displayed in a Query Profile that indicate that intermediate results do not fit in memory? (Choose two.)

    Correct Answer: C, D

    In the context of a Query Profile, if intermediate results do not fit in memory, they are typically spilled to storage. The statistics that indicate this situation are 'Bytes spilled to local storage' and 'Bytes spilled to remote storage'. These metrics directly show that the intermediate results have exceeded the available memory and have been temporarily stored elsewhere.

Discussion
MarkantiOptions: CD

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

mambamotaOptions: CD

correct