SnowPro Core Certification — Question 218

What are common issues found by using the Query Profile? (Choose two.)

Answer options

• A. Identifying queries that will likely run very slowly before executing them
• B. Locating queries that consume a high amount of credits
• C. Identifying logical issues with the queries
• D. Identifying inefficient micro-partition pruning
• E. Data spilling to a local or remote disk

Correct answer: D, E

Explanation

The correct answers, D and E, relate to the performance optimization aspects of queries, specifically recognizing inefficient micro-partition pruning and data spilling issues. Options A, B, and C, while relevant to query performance, do not directly reflect the issues the Query Profile is designed to uncover.