SnowPro Core Certification — Question 229

To add or remove search optimization for a table, a user must have which of the following privileges or roles? (Choose two.)

Answer options

• A. The MODIFY privilege on the table
• B. The OWNERSHIP privilege on the table
• C. A SECURITYADMIN role
• D. The ADD SEARCH OPTIMIZATION privilege on the schema that contains the table
• E. The SELECT privilege on the table

Correct answer: B, D

Explanation

The OWNERSHIP privilege on the table (B) allows a user to make changes to its search optimization settings, while the ADD SEARCH OPTIMIZATION privilege on the schema (D) is required to apply that optimization. The other options do not provide the necessary permissions for modifying search optimization settings.