Queries Not Supported By the Search Optimization Service¶ The search optimization service does not support the following: External tables. Materialized views. Columns defined with a COLLATE clause. Column concatenation. Analytical expressions. Casts on table columns (except for fixed-point numbers cast to strings). https://docs.snowflake.com/en/user-guide/search-optimization-service#label-search-optimization-service-supported-data-types

All four looks incorrect A, B & D are incorrect as per https://docs.snowflake.com/en/user-guide/search-optimization-service#:~:text=Queries%20Not%20Supported%20By%20the%20Search%20Optimization%20Service%C2%B6 and C is s twisted statement and leans towards the correct answer as per this https://docs.snowflake.com/en/user-guide/search-optimization-service#:~:text=Tables%20with%20Masking%20Policies%20and%20Row%20Access%20Policies%C2%B6

C A, B and D are explicitly excluded https://docs.snowflake.com/en/user-guide/search-optimization/queries-that-benefit Additionally, the search optimization service does not support the following: External tables. Materialized views. Columns defined with a COLLATE clause. Column concatenation. Analytical expressions. Casts on table columns (except for fixed-point numbers cast to strings).

should be D The search optimization service can improve query performance for tables that use masking policies and row access policies. https://docs.snowflake.com/en/user-guide/search-optimization-service

https://docs.snowflake.com/en/user-guide/search-optimization-service

I think