SnowPro Core Certification — Question 645

What does Snowflake's search optimization service support?

Answer options

• A. External tables
• B. Materialized views
• C. Tables and views that are not protected by row access policies
• D. Casts on table columns (except for fixed-point numbers cast to strings)

Correct answer: C

Explanation

The correct answer is C because the search optimization service is designed to enhance performance for tables and views that do not have row access policies applied. Options A and B are incorrect as they do not pertain to the specifics of the search optimization service, and option D is also incorrect because it relates to casting rather than search optimization.