What does Snowflake's search optimization service support?

The correct answer is C. Tables and views that are not protected by row access policies. Snowflake's search optimization service supports tables and views that are not protected by row access policies. It is designed to improve the performance of certain types of queries on tables, including selective point lookup queries and queries on fields in VARIANT, OBJECT…

Performance Management

Question

Options

AExternal tables
BMaterialized views
CTables and views that are not protected by row access policies
DCasts on table columns (except for fixed-point numbers cast to strings)

How the community answered

(26 responses)

A
4% (1)
C
92% (24)
D
4% (1)

Explanation

Snowflake's search optimization service supports tables and views that are not protected by row access policies. It is designed to improve the performance of certain types of queries on tables, including selective point lookup queries and queries on fields in VARIANT, OBJECT, and ARRAY (semi- structured) columns.

Topics

#Search Optimization Service#Performance Tuning#Query Performance#Service Limitations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice