Answer-first summary for fast verification
Answer: Geography value column searches using geospatial functions
The correct answer is D because the Search Optimization Service in Snowflake specifically supports geospatial functions with GEOGRAPHY values, as documented in the official Snowflake documentation. The community discussion shows 100% consensus on answer D with upvoted comments referencing the official documentation link. Options A, B, and C are not supported query types for the Search Optimization Service - column concatenation, substring searches on external tables, and COLLATE function usage do not benefit from this optimization service.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which query types are supported for implementing the Search Optimization Service?
A
Queries with column concatenation
B
Substring search queries on external tables
C
String searches on columns using the COLLATE function
D
Geography value column searches using geospatial functions