Which statement about the Snowflake Search Optimization service is true?

• A. You must have ADD SEARCH OPTIMIZATION privilege on the table
• B. A search access path becomes invalid if you add, drop, or rename a column
• C. Search optimization service does not support materialized views
• D. Search optimization service does not support VARCHAR and TIMESTAMP data types

Answer: (C)

Snowflake's Search Optimization service is a feature you enable on base tables to speed up lookups by creating a specialized search access path for filtering predicates. It operates at the table level and is configured by altering the table to add the optimization.

The statement that is true is that the search optimization service does not support materialized views. Materialized views are precomputed results with their own update mechanics, and the search optimization path is not applicable to them. In Snowflake, this optimization is designed for regular tables, not for materialized views, which is why this option is the correct one.

The other options don’t align with how the feature works: enabling search optimization relies on modifying the table’s properties (and the related privileges are tied to table modification, not a separate “ADD SEARCH OPTIMIZATION” privilege); the service supports common data types used in filtering, including VARCHAR and TIMESTAMP; and changes to a table’s schema don’t typically render the search path invalid in the way those statements describe.