Exam SnowPro Core topic 1 question 832 discussion

Actual exam question from Snowflake's SnowPro Core

Question #: 832
Topic #: 1

[All SnowPro Core Questions]

How does the search optimization service help Snowflake users improve query performance?

A. It scans the micro-partitions based on the joins used in the queries and scans only join columns.
B. It maintains a persistent data structure that keeps track of the values of the table’s columns in each of its micro-partitions.
C. It scans the local disk cache to avoid scans on the tables used in the query.
D. It keeps track of running queries and their results and saves those extra scans on the table.

Show Suggested Answer

Suggested Answer: B 🗳️

by Heetec at Oct. 10, 2023, 9:06 p.m.

Comments

Submit Cancel

BobFar

7 months, 2 weeks ago

B Correct . To improve performance for point lookups, the search optimization service creates and maintains a persistent data structure called a search access path. The search access path keeps track of which values of the table’s columns might be found in each of its micro-partitions, allowing some to be skipped when scanning the table. https://docs.snowflake.com/en/user-guide/search-optimization-service#how-does-the-search-optimization-service-work

upvoted 3 times

...

Heetec

8 months, 1 week ago

Selected Answer: B

B correct - https://docs.snowflake.com/en/user-guide/search-optimization-service

upvoted 2 times

...