Snowpro Core · Free Practice Question Easy
Question 55
Which of the following statements is true about the Search Optimization Service in Snowflake?
-
A
It supports all query types, including aggregations and joins.
-
B
It adds a search access path for efficient lookups and is maintained automatically by Snowflake.
-
C
It is enabled automatically on all tables when using the Enterprise Edition.
-
D
It requires a virtual warehouse to operate.
Reveal correct answer
Correct answer: B
A.
The service is designed for selective queries and does not support aggregations or joins as part of its optimization.
B.
The Search Optimization Service creates a search access path to speed up specific queries (e.g., point lookups, substring searches) and is managed automatically by Snowflake once it is enabled. This means that Snowflake takes care of the maintenance and updates without user intervention.
C.
It is not automatically enabled on all tables; users must explicitly enable it on specific tables or columns.
D.
The Search Optimization Service is a serverless feature and does not require a virtual warehouse to operate.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
