SnowPro Core Certification — Question 166
Which of the following significantly improves the performance of selective point lookup queries on a table?
Answer options
- A. Clustering
- B. Materialized Views
- C. Zero-copy Cloning
- D. Search Optimization Service
Correct answer: D
Explanation
The Search Optimization Service is designed to accelerate the performance of selective point lookup queries by providing optimized access paths. Clustering and Materialized Views can improve performance in different scenarios but do not specifically target point lookups as effectively as the Search Optimization Service. Zero-copy Cloning is related to data management but does not enhance query performance directly.