SnowPro Core Certification — Question 966

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

Answer options

• A. Bytes scanned
• B. Partitions scanned
• C. Bytes spilled to local storage
• D. Bytes spilled to remote storage
• E. Percentage scanned from cache

Correct answer: C, D

Explanation

The correct answers, C and D, indicate that data has been written to local and remote storage due to insufficient memory for intermediate results. The other options do not specifically indicate memory limitations; for instance, Bytes scanned and Partitions scanned refer to the amount of data processed, while Percentage scanned from cache shows efficiency, not memory overflow.