Answer-first summary for fast verification
Answer: When there are exploding joins, When there is a UNION without ALL
The Query Profile in Snowflake helps identify performance issues by showing query execution details. Option B (exploding joins) is correct because these produce excessive result records, which the Query Profile clearly shows through high row counts and processing times. Option C (UNION without ALL) is correct because it requires deduplication, which the Query Profile reveals through additional compute operations and processing steps. The community discussion with 100% consensus and upvoted comments confirms BC as the correct answers, citing Snowflake documentation that mentions the Query Profile helps identify issues like exploding joins and inefficient operations. Other options are incorrect: A (incorrect window functions) is more about logical errors than performance patterns the Query Profile highlights; D (SELECT DISTINCT with too many values) is vague and not a specific Query Profile troubleshooting use case; E (CTEs without final SELECT) is a syntax error, not a performance issue the Query Profile helps troubleshoot.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which common query problems can the Query Profile help a user identify and troubleshoot? (Choose two.)
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