nerdexam
Snowflake

COF-R02 · Question #240

Which of the following significantly improves the performance of selective point lookup queries on a table?

The correct answer is A. Clustering. See the full explanation below for the reasoning.

Question

Which of the following significantly improves the performance of selective point lookup queries on a table?

Options

  • AClustering
  • BMaterialized Views
  • CZero-copy Cloning
  • DSearch Optimization Service

How the community answered

(36 responses)
  • A
    78% (28)
  • B
    11% (4)
  • C
    3% (1)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full COF-R02 Practice