SnowPro Core Certification — Question 1151

What does a Query Profile metric that shows excessive spillage indicate?

Answer options

• A. Poor query optimization
• B. Expired temporary tables
• C. Improper virtual warehouse sizing
• D. Improper Common Table Expressions (CTEs)

Correct answer: C

Explanation

A Query Profile metric showing excessive spillage typically indicates that the virtual warehouse is not appropriately sized for the workload, leading to inefficiency. The other options, while potentially related to performance issues, do not directly correlate to spillage as a metric in query profiles.