SnowPro Advanced: Architect — Question 65

What is a key consideration when setting up search optimization service for a table?

Answer options

• A. Search optimization service works best with a column that has a minimum of 100 K distinct values.
• B. Search optimization service can significantly improve query performance on partitioned external tables.
• C. Search optimization service can help to optimize storage usage by compressing the data into a GZIP format.
• D. The table must be clustered with a key having multiple columns for effective search optimization.

Correct answer: A

Explanation

The correct answer is A because search optimization services require a substantial number of distinct values to function efficiently. Option B is incorrect as it discusses query performance improvements without addressing the distinct values requirement. Option C focuses on storage optimization, which is not the primary concern for setting up search optimization. Option D is also wrong because effective search optimization does not necessarily require clustering with multiple column keys.