Answer: Inefficient query pruning, Exploding joins

The Query Profile in Snowflake is designed to help identify performance issues in queries. Based on the community discussion and Snowflake documentation references provided, the two correct answers are B (Inefficient query pruning) and D (Exploding joins). Inefficient pruning occurs when queries don't effectively filter data early in the execution process, leading to unnecessary data processing. Exploding joins happen when join operations produce significantly more rows than expected, often due to many-to-many relationships. The community discussion shows 100% consensus on BD, with multiple users referencing official Snowflake documentation that specifically lists these as common query problems identified by Query Profile. Options A, C, and E are incorrect because insufficient credit quota and credit usage thresholds are billing/account management issues, not query performance problems identified by Query Profile, and excessive query pruning is not a typical problem category in this context.

Author: LeetQuiz Editorial Team