How can a Snowflake user optimize query performance in Snowflake? (Choose two.)
How can a Snowflake user optimize query performance in Snowflake? (Choose two.)
Optimizing query performance in Snowflake can be achieved by clustering a table and enabling the search optimization service. Clustering a table physically reorganizes its data for more efficient access patterns, especially for queries that filter on specific columns. The search optimization service enhances query performance by creating a search index that is used to quickly locate data based on specified criteria. Creating a view does not inherently optimize performance, and enabling Time Travel is useful for data recovery but does not directly impact query performance through optimization. Indexing a table is not a native Snowflake feature for optimization as in traditional database systems.
The correct answers are B and C. Clustering a table physically reorders the rows in a table to improve the performance of queries that filter on specific columns. The search optimization service creates a search index for a table, which can be used to improve the performance of queries that filter on specific columns. Creating a view does not improve query performance. Enabling Time Travel allows you to query data from a specific point in time, but it does not improve query performance. Indexing a table creates an index that can be used to improve the performance of queries, but it is not as effective as clustering or the search optimization service.
BC is correct
BC correct
BC is corect