SnowPro Core Certification — Question 663

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

Answer options

• A. Bytes spilled to local cache.
• B. Bytes spilled to local storage.
• C. Bytes spilled to remote cache.
• D. Bytes spilled to remote storage.
• E. Bytes spilled to remote metastore.

Correct answer: B, D

Explanation

The correct answers, B and D, refer to bytes that are spilled to local storage and remote storage, indicating that the query's size has exceeded the available memory. Options A and C pertain to cache and do not necessarily imply memory issues, while E is unrelated as it involves the metastore.