COF-C02 Question #420: Real Exam Question with Answer & Explanation

The correct answer is C: GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>. To utilize the search optimization service in Snowflake, the correct syntax for granting privileges to a role involves specific commands that include adding search optimization capabilities: Option C: GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>. This comm

Account Access and Security

Question

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

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>

Explanation

To utilize the search optimization service in Snowflake, the correct syntax for granting privileges to a role involves specific commands that include adding search optimization capabilities: Option C: GRANT ADD SEARCH OPTIMIZATION ON SCHEMA <schema_name> TO ROLE <role>. This command grants the specified role the ability to implement search optimization at the schema level, which is essential for enhancing search capabilities within that schema. Options A and B do not include the correct verb "ADD," which is necessary for this specific type of grant command in Snowflake. Option D incorrectly mentions the database level, as search optimization privileges are typically configured at the schema 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 Browse All COF-C02 Questions