SnowPro Advanced: Architect — Question 156

An Architect has implemented the search optimization service for a table. A user adds a new column to the table and there is a decrease in query performance.

The Architect then executes the DESCRIBE SEARCH OPTIMIZATION command and finds that the newly-added column was not included in the search access path.

Why did this occur?

Answer options

• A. The new column has a data type that is not supported by the search optimization service.
• B. The new column is automatically included in the search access path, but there is a time delay before it takes effect.
• C. The ON clause was used when enabling the search optimization service, which does not automatically include new columns.
• D. The SEARCH OPTIMIZATION property needs to be dropped and then added back for the changes to take effect.

Correct answer: C

Explanation

The correct answer is C because using the ON clause when enabling the search optimization service only includes specific columns, excluding any new ones added afterward. Options A and B are incorrect as they do not address the issue of inclusion in the search access path, while D is also not applicable since the property does not need to be dropped for new columns to be recognized.