SnowPro Core Certification — Question 1161

How does the search optimization service improve query performance?

Answer options

• A. By clustering the tables
• B. By creating a persistent data structure
• C. By using caching
• D. By optimizing the use of micro-partitions

Correct answer: B

Explanation

The correct answer is B, as creating a persistent data structure allows for more efficient data retrieval and query execution. Clustering tables (A), caching (C), and optimizing micro-partitions (D) can contribute to performance but do not fundamentally enhance query processing like a persistent data structure does.