SnowPro Core Certification — Question 1045

Which common query issues can be identified by the Query Profile? (Choose two.)

Answer options

• A. Insufficient credit quota
• B. Inefficient query pruning
• C. Excessive query pruning
• D. Exploding joins
• E. Credit usage that exceeds a set threshold

Correct answer: B, D

Explanation

The Query Profile is effective in identifying issues such as inefficient query pruning (B), which indicates that the query is not optimizing its processing well, and exploding joins (D), which can lead to performance degradation due to excessive data combinations. The other options, while relevant to query management, do not specifically relate to the insights provided by the Query Profile.