What common query issues can be identified using the Query Profile? (Choose two.)
What common query issues can be identified using the Query Profile? (Choose two.)
The common query issues that can be identified using the Query Profile are exploding joins and inefficient pruning. Exploding joins occur when data joins result in an unexpectedly large result set, often slowing down the query. Inefficient pruning refers to when the database is unable to effectively limit the amount of data scanned for a query, which can also lead to performance issues. Therefore, the correct answers are exploding joins and inefficient pruning.
Exploding joins and Inefficient pruning https://docs.snowflake.com/en/user-guide/ui-query-profile#common-query-problems-identified-by-query-profile
B and D https://docs.snowflake.com/en/user-guide/ui-query-profile
BD are correct
correct
for sure