How can a Snowflake user optimize query performance in Snowflake? (Select TWO).

The correct answer is B. Cluster a table. C. Enable the search optimization service. Clustering a table (B) defines clustering keys that physically co-locate related data in micro-partitions, which reduces the number of partitions scanned for queries that filter on those keys - directly improving query performance. The Search Optimization Service (C) builds a…

Performance Management

Question

Options

ACreate a view.
BCluster a table.
CEnable the search optimization service.
DEnable Time Travel.
EIndex a table.

How the community answered

(49 responses)

A
2% (1)
B
96% (47)
D
2% (1)

Explanation

Clustering a table (B) defines clustering keys that physically co-locate related data in micro-partitions, which reduces the number of partitions scanned for queries that filter on those keys - directly improving query performance. The Search Optimization Service (C) builds a persistent search access path structure for tables, dramatically speeding up selective point lookup queries and queries with equality or range predicates on high-cardinality columns. Creating a view (A) is simply a named query definition and does not improve performance on its own. Enabling Time Travel (D) adds data retention for historical queries but has no effect on query speed. Indexing (E) is not a feature in Snowflake - Snowflake uses micro-partition pruning instead of traditional indexes.

Topics

#Query optimization#Automatic Clustering#Search Optimization Service#Performance tuning

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice