SnowPro Core Certification — Question 995

Which query type is supported for implementing the search optimization service?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D because geography value column searches are specifically designed to work with geospatial functions, which are integral to the search optimization service. The other options either involve different types of queries or functionalities that are not supported by this service.