SnowPro Core Certification — Question 381

What type of query benefits the MOST from search optimization?

Answer options

• A. A query that uses only disjunction (i.e., OR) predicates
• B. A query that includes analytical expressions
• C. A query that uses equality predicates or predicates that use IN
• D. A query that filters on semi-structured data types

Correct answer: C

Explanation

The correct answer is C because equality predicates and IN conditions are often highly efficient for search optimization, allowing for faster data retrieval. Options A and B do not leverage the same level of optimization, while D deals with semi-structured data, which may introduce complexity that hinders optimization.