SnowPro Core Certification — Question 801

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

Answer options

• 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.

Correct answer: B

Explanation

The correct answer, B, correctly describes that the search optimization service maintains a persistent data structure that tracks column values across micro-partitions, which helps in quickly locating the necessary data. Option A is incorrect as it only focuses on join columns, while options C and D do not accurately represent the role of the search optimization service in improving query performance.