Which data types are supported by the Search Optimization service?

• A. Integer and Varchar only
• B. Fixed-point numbers (Integer, Numeric), Date, Time, Timestamp, Varchar, Binary, Variant, Object, Array (In Preview), Geography (In Preview)
• C. Date and Timestamp only
• D. Variant only

Answer: (B)

The Search Optimization service is designed to speed up queries by indexing and efficiently locating values across a wide range of data types, not just simple numbers or text. It supports both standard and semi-structured data, including numeric types (Integer and Numeric), temporal types (Date, Time, Timestamp), and strings (Varchar). It also handles Binary data.

For semi-structured data, it supports Variant and Object, and it can work with Array data in Preview, as well as Geography data in Preview. The note about Preview means these features are available for testing and may evolve, but they are currently supported in this context.

Because this option reflects the full breadth of data types the service can optimize for, including those in Preview, it’s the most complete and accurate choice.