nerdexam
Snowflake

COF-R02 · Question #124

Which Snowflake technique can be used to improve the performance of a query?

The correct answer is A. Clustering. https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Querying and Performance

Question

Which Snowflake technique can be used to improve the performance of a query?

Options

  • AClustering
  • BIndexing
  • CFragmenting
  • DUsing INDEX__HINTS

How the community answered

(23 responses)
  • A
    70% (16)
  • B
    9% (2)
  • C
    17% (4)
  • D
    4% (1)

Explanation

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Topics

#clustering#query performance#optimization

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice