Exam SnowPro Core topic 1 question 144 discussion

The correct answer is C. 2: Below are the recommended checks to consider for the query: At least one of the columns accessed through the query filter operation has at least 100k-200k distinct values. The query uses equality predicate or predicates that use IN. The query returns a few rows with highly selective filters. The query typically runs for at least tens of seconds. https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

C.A query that uses equality predicates or predicates that use IN

Correct Answer: C

C. A query that uses equality predicates or predicates that use IN

Correct Answer is B. Analytical expression , the answer C is only for Variant, Objects and Array data type. https://docs.snowflake.com/en/user-guide/search-optimization-service

Correct

The answer is C.

C. A query that uses equality predicates or predicates that use IN

Should be B. The search optimization service can significantly improve the performance of certain types of lookup and analytical queries that use an extensive set of predicates for filtering. Query uses equality predicate or predicates that use IN only applies to VARIANT, OBJECT, and ARRAY columns . https://docs.snowflake.com/en/user-guide/search-optimization-service