Explanation:
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.
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.