Explanation:
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.
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