SnowPro Core Recertification — Question 21

What persistent data structures are used by the search optimization service to improve the performance of point lookups?

Answer options

• A. Micro-partitions
• B. Clustering keys
• C. Equality searches
• D. Search access paths

Correct answer: D

Explanation

Search access paths are essential for optimizing point lookups as they provide a structured way to access specific data quickly. Micro-partitions, clustering keys, and equality searches do not specifically focus on improving the lookup performance in the same way that search access paths do.