How does the search optimization service function?

• A. Relies on a persistent data structure that serves as an optimized search access path
• B. Creates per-query temporary indexes
• C. Caches all data in memory
• D. Requires manual indexing

Answer: (A)

The idea tested is that the Search Optimization Service speeds up data access by using a persistent index-like structure that sits with the data and provides an optimized path for searches. This structure is maintained automatically by Snowflake and remains available over time, rather than being created anew for each query. It enables quicker point lookups and range scans by letting the optimizer prune and locate relevant micro-partitions efficiently, without the need to rebuild indexes every time. It isn’t simply caching all data in memory, and it doesn’t require you to manually create or manage indexes—the service builds and maintains this durable search path for you.