Answer: Bytes spilled to local storage, Bytes spilled to remote storage

The Query Profile in Snowflake displays statistics that help identify performance issues. When intermediate results do not fit in memory, Snowflake spills data to storage. 'Bytes spilled to local storage' (C) and 'Bytes spilled to remote storage' (D) directly indicate that memory was insufficient, forcing data to be written to disk. These metrics are highlighted in the Query Profile documentation and confirmed by the community consensus (100% agreement on CD). Options A (Bytes scanned) and B (Partitions scanned) relate to data read operations, not memory constraints. Option E (Percentage scanned from cache) measures cache efficiency, not memory spills. Thus, C and D are the correct choices.

Author: LeetQuiz Editorial Team