SnowPro Core Certification — Question 990

What issues can be identified and troubleshooted using the Query Profile? (Choose two.)

Answer options

• A. Full index scans
• B. Cartesian products
• C. Insufficient privileges
• D. Queries too large to fit in memory
• E. Virtual warehouse credit consumption

Correct answer: B, D

Explanation

The Query Profile can effectively identify Cartesian products, which occur when a query returns a combination of all rows from two or more tables, leading to inefficiencies. It can also detect queries that are too large to fit in memory, which could cause performance issues. The other options, such as full index scans, insufficient privileges, and virtual warehouse credit consumption, are not specifically identified through the Query Profile.