Snowpro Core · Free Practice Question Medium
Question 68
Which of the following statements correctly describe Search Optimization in Snowflake? Select all that apply.
- A The search optimization service is like materialized view functionality.
- B The search optimization service in Snowflake is similar to the secondary index concept in typical databases.
- C The search optimization service can significantly enhance the performance of some lookup and analytical queries that use many predicates for filtering.
Reveal correct answers
Correct answers: B, C
Explanation
The search optimization service can significantly enhance the performance of some lookup and analytical queries that use many predicates for filtering. The search optimization service uses a persistent data structure as an optimized search access path to speed up point lookups. When you enable search optimization for a table, the maintenance service creates the search access path and populates it with the data required for lookups. Depending on the size of the table, the process of populating the search optimization data can take some time. The search optimization service performs this update in the background, so it does not interfere with other actions on the table. https://docs.snowflake.com/en/user-guide/search-optimization-serviceDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
