Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
What privilege is required to enable the search optimization service on a table in Snowflake?
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]_