Which features could be used to improve the performance of queries that return a small subset of rows from a large table? (Select TWO).

Question

Options

• ASearch optimization service
• BAutomatic clustering
• CRow access policies
• DMulti-cluster virtual warehouses
• ESecure views

• A
  89% (31)
• C
  3% (1)
• D
  6% (2)
• E
  3% (1)

Explanation

Both the Search Optimization Service (A) and Automatic Clustering (B) are designed specifically to improve the performance of selective queries on large tables. The Search Optimization Service builds a dedicated access path that helps Snowflake quickly locate matching micro-partitions for point lookups and equality/range predicates, avoiding full table scans. Automatic Clustering continuously maintains the table's clustering key order so that filtering on those keys results in aggressive micro-partition pruning - fewer partitions are scanned when only a small subset of rows is needed. Row access policies (C) enforce data security but do not improve query speed. Multi-cluster virtual warehouses (D) help with concurrency, not single-query performance on selective lookups. Secure views (E) add a security layer but do not enhance query performance.

No community discussion yet for this question.