To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)
To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)
To add or remove search optimization for a table, a user must have the OWNERSHIP privilege on the table and the ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. The OWNERSHIP privilege on the table is required as it grants full control, allowing the user to modify its properties. The ADD SEARCH OPTIMIZATION privilege is required specifically to manage search optimization settings within the schema.
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#what-access-control-privileges-are-needed-for-the-search-optimization-service
To add, configure, or remove search optimization for a table, you must have the following privileges: You must have OWNERSHIP privilege on the table. You must have ADD SEARCH OPTIMIZATION privilege on the schema that contains the table. https://docs.snowflake.com/en/user-guide/search-optimization-service.html#what-access-control-privileges-are-needed-for-the-search-optimization-service
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#what-access-control-privileges-are-needed-for-the-search-optimization-service
BD are correct
https://docs.snowflake.com/en/user-guide/search-optimization/enabling
correct
https://docs.snowflake.com/en/user-guide/search-optimization/enabling#required-access-control-privileges
Correct
https://docs.snowflake.com/en/user-guide/search-optimization-service.html#what-access-control-privileges-are-needed-for-the-search-optimization-service