SnowPro Core Certification — Question 703

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

Answer options

• A. GRANT SEARCH OPTIMIZATION ON SCHEMA [schema_name] TO ROLE [role]
• B. GRANT SEARCH OPTIMIZATION ON DATABASE [database_name] TO ROLE [role]
• C. GRANT ADD SEARCH OPTIMIZATION ON SCHEMA [schema_name] TO ROLE [role]
• D. GRANT ADD SEARCH OPTIMIZATION ON DATABASE [database_name] TO ROLE [role]

Correct answer: C

Explanation

The correct answer is C because the 'GRANT ADD SEARCH OPTIMIZATION' command specifically allows a role to add search optimization on a schema, which is necessary for using the service. Options A and B do not provide the required 'ADD' permission, and option D is incorrect because it pertains to databases instead of schemas.