Snowflake COF-C03 Exam - Topic 1 Question 11 Discussion

Question

When retrieving data from a table which type of query will benefit the MOST from use of the search optimization service?

Jean · Accepted Answer

C) Queries on fields in a VARIANT column that will return all data as structured data.

Jean · Answer

A) Queries with unpredictable data volumes.

Jean · Answer

B) Queries with highly-selective table filters that return a small subset of rows.

Jean · Answer

D) Queries that involve one or more columns inside the cluster key using the lowest cardinality to select filters.