Answer: Tables and views that are not protected by row access policies

The correct answer is C because Snowflake's Search Optimization Service supports tables and views that are not protected by row access policies. According to the official Snowflake documentation and community consensus (with 82% selecting C and upvoted comments referencing the docs), the service explicitly does NOT support: external tables (A), materialized views (B), or casts on table columns except for fixed-point numbers cast to strings (D). The service can improve query performance for tables with masking policies and row access policies, but the question specifically asks what the service supports, making C the accurate choice as it correctly identifies supported objects.

Author: LeetQuiz Editorial Team