Which statement accurately describes the scope of Snowflake's Search Optimization Service?

• A. It is a database-level feature.
• B. It is a per-column feature.
• C. It is a table-level property and applies to all columns with supported data types.
• D. It applies only to string columns.

Answer: (C)

The main idea being tested is where Snowflake’s Search Optimization Service is applied and how broadly it affects data. This service is configured at the table level, meaning you enable it for a specific table and it governs how that table’s data is stored and scanned. It isn’t a database-wide setting, and it isn’t limited to a single column. Instead, once enabled on a table, the optimization applies across all columns in that table that have supported data types. That’s why the statement describing it as a table-level property that applies to all columns with supported data types is the best description. The feature accelerates queries by speeding up how the table’s data is pruned and scanned, regardless of which non-string or string columns are involved, as long as they are of a supported type.