Answer-first summary for fast verification
Answer: The OWNERSHIP privilege on the table, The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
According to Snowflake documentation and the community consensus (100% agreement with 7 upvotes on the top comment), to add or remove search optimization for a table, a user must have: (B) OWNERSHIP privilege on the table, and (D) ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. The OWNERSHIP privilege is required because modifying search optimization settings is a table-level administrative operation. The ADD SEARCH OPTIMIZATION privilege on the schema is specifically designed for enabling search optimization services. Other options are incorrect: (A) MODIFY privilege is insufficient, (C) SECURITYADMIN role doesn't grant these specific privileges, and (E) SELECT privilege only allows data reading, not administrative changes.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which privileges or roles must a user have to add or remove search optimization on a table? (Select two.)
A
The MODIFY privilege on the table
B
The OWNERSHIP privilege on the table
C
A SECURITYADMIN role
D
The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
E
The SELECT privilege on the table
No comments yet.