Answer: Exploding joins, Inefficient pruning

The Query Profile in Snowflake is designed to identify specific query performance problems. According to the official Snowflake documentation referenced in the community discussion, the common query problems identified by Query Profile include 'Exploding joins' (option B) and 'Inefficient pruning' (option D). Exploding joins occur when join operations produce significantly more rows than expected, while inefficient pruning refers to poor partition elimination in queries. The community discussion shows 100% consensus on BD, with multiple users citing the official documentation that specifically lists these two issues. Options A (Data classification), C (Unions), and E (Data masking) are not among the common query problems explicitly identified by Query Profile according to the documentation.

Author: LeetQuiz Editorial Team