SnowPro Core Certification — Question 915

Which common query problems are identified by the Query Profile? (Choose two.)

Answer options

• A. Syntax error
• B. Inefficient pruning
• C. Ambiguous column names
• D. Queries too large to fit in memory
• E. Object does not exist or not authorized

Correct answer: B, D

Explanation

The correct answers, B and D, point out issues related to query performance and resource limitations. 'Inefficient pruning' indicates problems with how data is filtered, while 'Queries too large to fit in memory' refers to memory constraints. The other options, such as syntax errors and unauthorized objects, are not specifically identified by the Query Profile.