
Answer-first summary for fast verification
Answer: Search optimization service, Automatic clustering
The question asks for features that improve performance when querying a small subset of rows from a large table. Option A (Search optimization service) is designed to optimize point lookups and small range scans, directly addressing this scenario by creating additional data structures for faster access. Option B (Automatic clustering) maintains the physical order of data based on clustering keys, which improves query performance when filtering on those keys by reducing the amount of data scanned. The community discussion strongly supports A and B with 100% consensus and multiple upvoted comments. Options C (Row access policies) and E (Secure views) are security features that don't directly improve query performance. Option D (Multi-cluster virtual warehouses) addresses concurrency scaling but doesn't specifically optimize for retrieving small subsets from large tables.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which features can be used to enhance the performance of queries that retrieve a small subset of rows from a large table? (Choose two.)
A
Search optimization service
B
Automatic clustering
C
Row access policies
D
Multi-cluster virtual warehouses
E
Secure views