SnowPro Core Certification — Question 1126

Which Snowflake feature improves the performance of point lookup queries?

Answer options

• A. Materialized views
• B. Automatic clustering
• C. Query acceleration service
• D. Search optimization service

Correct answer: D

Explanation

The Search Optimization Service in Snowflake is specifically designed to speed up point lookup queries by maintaining optimized data structures. Materialized views, automatic clustering, and the query acceleration service serve different purposes and do not target point lookups directly, making them less effective in this context.