Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 809

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

When window functions are used incorrectly

When there are exploding joins

When there is a UNION without ALL

When the SELECT DISTINCT command returns too many values

When there are Common Table Expressions (CTEs) without a final SELECT statement

Correct Answer: B, C

The Query Profile can help identify and troubleshoot issues related to exploding joins, which produce an excessive number of result records, and the use of UNION without ALL, which requires additional computation to remove duplicate records.

Discussion

HeetecOptions: BC

BC correct - https://www.snowflake.com/blog/new-approaches-visualizing-snowflake-query-statistics/#:~:text=For%20years%2C%20our%20documentation%20has%20helped%20customers%20identify,pruning%20%28most%20often%20evidenced%20by%20large%20table%20scans%29

indunaOptions: BC

B - Exploding JOIN well they are almost always bad produces a ton of result records C - UNION without ALL needs extra compute to dedupe the combined results