Answer: Search access paths

The search optimization service in Snowflake creates and maintains persistent data structures called 'search access paths' to improve performance of point lookups. These search access paths track which values of table columns might be found in each micro-partition, allowing the query engine to skip scanning micro-partitions that don't contain the searched values. This is confirmed by the community discussion where all responses (100%) select option D, with upvoted comments citing official Snowflake documentation and explaining that search access paths are the specific persistent data structures maintained by the search optimization service for this purpose. While micro-partitions (A) are the underlying storage structure and clustering keys (B) help with data organization, neither are the persistent data structures specifically created by the search optimization service. Equality searches (C) describe the type of query being optimized, not the data structure itself.

Author: LeetQuiz Editorial Team