SnowPro Core Certification — Question 1060

How can performance be optimized for a query that returns a small amount of data from a very large base table?

Answer options

• A. Use clustering keys
• B. Create materialized views
• C. Use the search optimization service
• D. Use the query acceleration service

Correct answer: C

Explanation

The search optimization service is specifically designed to improve query performance for scenarios involving large datasets by optimizing how data is accessed. Clustering keys and materialized views may help in other contexts but are not as effective for small data retrieval from large tables. The query acceleration service is more focused on speeding up overall query processing rather than specifically optimizing for small result sets.