SnowPro Advanced: Data Engineer — Question 85

What action could a Data Engineer take to increase the query performance of an external table?

Answer options

• A. Add a clustering key to the external table.
• B. Enable the search optimization service on the external table.
• C. Create a materialized view on the external table.
• D. Set the USE_CACHED_RESULTS parameter to True for the external table.

Correct answer: C

Explanation

Creating a materialized view on the external table allows for pre-computed query results, which significantly boosts performance. The other options, while beneficial in certain contexts, do not directly improve query performance as effectively as a materialized view does.