Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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]
