An Architect has a VPN_ACCESS_LOGS table in the SECURITY_LOGS schema containing timestamps of the connection and disconnection, username of the user, and summary statistics.
What should the Architect do to enable the Snowflake search optimization service on this table?
To enable the Snowflake search optimization service on the VPN_ACCESS_LOGS table in the SECURITY_LOGS schema, the Architect needs to have OWNERSHIP privilege on the VPN_ACCESS_LOGS table and the ADD SEARCH OPTIMIZATION privilege on the SECURITY_LOGS schema. These permissions are necessary to configure search optimization for the specific table within the given schema.
https://docs.snowflake.com/en/user-guide/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.
Answer is C and is validated