Answer: Search Optimization Service

The question asks which option significantly improves the performance of selective point lookup queries on a table. Selective point lookup queries return only one or a small number of distinct rows based on specific filtering predicates. According to Snowflake documentation and the community discussion (with 100% consensus and multiple upvoted comments), the Search Optimization Service (option D) is specifically designed to optimize such queries by improving predicate filtering performance. Clustering (A) is more suited for range queries and data organization, not point lookups. Materialized Views (B) can improve performance but are for pre-computed results and not specifically for point lookups. Zero-copy Cloning (C) is for data management and copying without storage costs, not query performance. Thus, D is the correct and optimal choice.

Author: LeetQuiz Editorial Team