Answer: GRANT ADD SEARCH OPTIMIZATION ON SCHEMA [schema_name] TO ROLE [role]

According to Snowflake documentation and the community discussion with 100% consensus and upvoted comments, the ADD SEARCH OPTIMIZATION privilege on the schema level is required to enable search optimization service on a table. Option C is correct because: 1) The ADD SEARCH OPTIMIZATION privilege specifically grants the ability to add search optimization to tables, 2) This privilege must be granted at the schema level where the table resides, not the database level. Options A and B are incorrect because SEARCH OPTIMIZATION (without 'ADD') is not the correct privilege name. Option D is incorrect because the privilege must be granted at the schema level, not database level, as tables exist within schemas.

Author: LeetQuiz Editorial Team