SnowPro Core Certification — Question 369

The Snowflake Search Optimization Services supports improved performance of which kind of query?

Answer options

• A. Queries against large tables where frequent DML occurs
• B. Queries against tables larger than 1 TB
• C. Selective point lookup queries
• D. Queries against a subset of columns in a table

Correct answer: C

Explanation

The correct answer is C because Snowflake Search Optimization Services specifically optimizes for selective point lookup queries, allowing for faster access to specific data. Options A and B are not accurate as they refer to broader query types that do not benefit as directly from this service, and D is incorrect since it deals with column subsets rather than point lookups.