SnowPro Core Certification — Question 885

Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

Answer options

• A. Persisted query results
• B. QUERY_HISTORY view
• C. Query acceleration service
• D. Query Profile

Correct answer: D

Explanation

The Query Profile provides detailed insights into the execution of a query, allowing users to identify performance bottlenecks. In contrast, Persisted query results and QUERY_HISTORY view do not offer the same level of diagnostic detail, and the Query acceleration service is focused on improving query performance rather than troubleshooting.