SnowPro Core Certification — Question 335

Which Query Profile result indicates that a warehouse is sized too small?

Answer options

• A. There are a lot of filter nodes.
• B. Bytes are spilling to external storage.
• C. The number of processed rows is very high.
• D. The number of partitions scanned is the same as partitions total.

Correct answer: B

Explanation

The correct answer, B, indicates that data is spilling to external storage, which typically happens when the warehouse cannot handle the data volume efficiently. The other options suggest different performance characteristics but do not directly indicate a size limitation of the warehouse.