SnowPro Core Certification — Question 521

What common query issues can be identified using the Query Profile? (Choose two.)

Answer options

• A. Data classification
• B. Exploding joins
• C. Unions
• D. Inefficient pruning
• E. Data masking

Correct answer: B, D

Explanation

The correct answers, B (Exploding joins) and D (Inefficient pruning), are issues that can significantly impact query performance, which the Query Profile helps to identify. Options A (Data classification), C (Unions), and E (Data masking) do not typically relate to performance issues that the Query Profile is designed to highlight.