The correct answers are A. INTEGER and B. GEOMETRY .
The Snowflake Search Optimization Service can improve performance for selective queries by maintaining a search access path. It supports several data types depending on the type of search being optimized, including scalar equality searches and geospatial searches.
Why A is correct:
INTEGER is a numeric data type. Search optimization supports equality searches on supported scalar data types, including numeric types such as integers.
Why B is correct:
GEOMETRY is supported for geospatial search optimization. Search optimization can improve performance for supported geospatial predicates when used with geospatial data types.
Why the other options are less appropriate in this question:
C. FLOAT is not the best answer in this option set. Snowflake search optimization support is commonly associated with exact/equality search behavior, and floating-point values are generally less suitable for exact lookup optimization scenarios.
D. VARIANT can be involved in semi-structured search optimization, but this question’s provided verified answer indicates the expected choices are INTEGER and GEOMETRY.
E. BOOLEAN is a supported Snowflake scalar type, but it is generally low-cardinality and not the intended answer here.
Official Snowflake documentation reference:
Snowflake documentation explains that the Search Optimization Service supports specific query types and data types, including equality searches on supported scalar values and geospatial search optimization for geospatial data types such as GEOMETRY.
[Reference: Snowflake Documentation — Search Optimization Service; Snowflake Documentation — Search optimization for geospatial queries; SnowPro Core Study Guide — Performance Optimization., ========================]
