What is the SQL fragment used to add search optimization to a table?

• A. Add Search Optimization
• B. Enable Search Optimization
• C. Alter Table table_name Add Search Optimization
• D. Create Search Optimization

Answer: (C)

Adding search optimization to a table is done with an ALTER TABLE statement that targets that table and uses ADD SEARCH OPTIMIZATION. This DDL command modifies the table's metadata to enable the optimization, which is how Snowflake applies this feature. The other phrases aren’t valid SQL fragments for enabling this optimization, as they don’t perform the necessary alteration on an existing table.