SnowPro Core Certification — Question 1002

Which solution improves the performance of point lookup queries that return a small number of rows from large tables using highly selective filters?

Answer options

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

Correct answer: D

Explanation

The correct answer is D, as the Search optimization service is designed specifically to enhance the speed of point lookups using selective criteria. Options A and B, while useful for performance, do not specifically target the optimization of point lookup queries. Option C, the Query acceleration service, is more focused on improving query performance in general rather than specifically for point lookups.