Answer: Search optimization service

The Search Optimization Service (option D) is specifically designed to improve performance for point lookup queries that return a small number of rows from large tables using highly selective filters. As confirmed by the Snowflake documentation link provided in the community discussion and the 100% community consensus, this service optimizes selective queries by creating and maintaining additional metadata that enables faster data retrieval for such scenarios. Automatic clustering (A) primarily helps with range queries and data organization but not specifically point lookups. Materialized views (B) can improve performance but require pre-computation and maintenance overhead. Query acceleration service (C) is designed for complex analytical queries with large result sets, not selective point lookups.

Author: LeetQuiz Editorial Team