nerdexam
Snowflake

COF-R02 · Question #264

What are common issues found by using the Query Profile? (Choose two.)

The correct answer is A. Identifying queries that will likely run very slowly before executing them D. Identifying inefficient micro-partition pruning. See the full explanation below for the reasoning.

Question

What are common issues found by using the Query Profile? (Choose two.)

Options

  • AIdentifying queries that will likely run very slowly before executing them
  • BLocating queries that consume a high amount of credits
  • CIdentifying logical issues with the queries
  • DIdentifying inefficient micro-partition pruning
  • EData spilling to a local or remote disk

How the community answered

(28 responses)
  • A
    86% (24)
  • B
    4% (1)
  • C
    7% (2)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice