SnowPro Core Certification — Question 1129

How can the Query Profile be used to troubleshoot a problematic query?

Answer options

• A. It will indicate if a virtual warehouse memory is too small to run the query.
• B. It will indicate if a user lacks the privileges needed to run the query.
• C. It will indicate if a virtual warehouse is in auto-scale mode.
• D. It will indicate if the user has enough Snowflake credits to run the query.

Correct answer: A

Explanation

The correct answer, A, is accurate because the Query Profile can provide insights into memory usage, helping to identify if the virtual warehouse's memory is inadequate for the query. Options B, C, and D do not pertain to memory issues; they relate to user permissions, warehouse scaling, and credit availability respectively, which are not directly indicated by the Query Profile.