SnowPro Core Certification — Question 781

Which common query problems can the Query Profile help a user identify and troubleshoot? (Choose two.)

Answer options

• A. When window functions are used incorrectly
• B. When there are exploding joins
• C. When there is a UNION without ALL
• D. When the SELECT DISTINCT command returns too many values
• E. When there are Common Table Expressions (CTEs) without a final SELECT statement

Correct answer: B, C

Explanation

The correct answers, B and C, refer to specific query problems that can be analyzed through the Query Profile. Exploding joins can cause performance issues, while a UNION without ALL can lead to unintended data loss. The other options, while they may indicate issues, are not typically identified through the Query Profile.