SnowPro Core Certification — Question 1107
Which query types will have significant performance improvement when run using the search optimization service? (Choose two.)
Answer options
- A. Range searches
- B. Equality searches
- C. Substring searches
- D. Queries with IN predicates
- E. Queries with aggregation
Correct answer: B, D
Explanation
The correct answers are B and D because equality searches and queries with IN predicates can benefit significantly from the search optimization service, as they allow for faster lookups and processing. In contrast, range searches, substring searches, and queries with aggregation do not achieve the same level of improvement from this service.