SnowPro Core Certification — Question 573

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.

What should the user do?

Answer options

• A. Add a clustering key to the table.
• B. Add the search optimization service to the table.
• C. Create a materialized view based on the query.
• D. Enable the query acceleration service for the virtual warehouse.

Correct answer: C

Explanation

Creating a materialized view based on the query is the best choice because it pre-computes and stores the results, thus speeding up performance for queries that require significant processing. The other options, while useful for other scenarios, do not specifically address the need for optimizing performance for a query that processes a small number of rows.