SnowPro Core Certification — Question 502

Which of the following query profiler variables will indicate that a virtual warehouse is not sized correctly for the query being executed?

Answer options

• A. Bytes sent over the network
• B. Synchronization
• C. Initialization
• D. Remote spillage

Correct answer: D

Explanation

The correct answer, D, Remote spillage, indicates that data is being spilled to disk due to insufficient memory resources in the virtual warehouse. This suggests that the warehouse is not adequately sized for the workload. The other options, while they may provide useful information about query performance, do not specifically point to sizing issues.