Which privilege is required to use the search optimization service in Snowflake?

The correct answer is C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>. To enable the Search Optimization Service on a table, a user must have the ADD SEARCH OPTIMIZATION privilege. This privilege is granted at the schema level (covering all tables within that schema) or at the table level. The correct syntax is GRANT ADD SEARCH OPTIMIZATION ON…

Account Access and Security

Question

Options

AGRANT SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
BGRANT SEARCH OPTIMIZATION ON DATABASE <database_name> TO ROLE <role>
CGRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>
DGRANT ADD SEARCH OPTIMIZATION ON DATABASE <database name> TO ROLE <role>

How the community answered

(25 responses)

A
4% (1)
B
4% (1)
C
92% (23)

Explanation

To enable the Search Optimization Service on a table, a user must have the ADD SEARCH OPTIMIZATION privilege. This privilege is granted at the schema level (covering all tables within that schema) or at the table level. The correct syntax is GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>. Options A and B use the incorrect privilege name 'SEARCH OPTIMIZATION' (missing 'ADD'). Option D incorrectly targets the DATABASE level - search optimization is configured at the schema or table level, not the database level.

Topics

#Search Optimization#Privileges#Access Control#GRANT statement

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice