SnowPro Core Certification — Question 1180

How can the performance of queries run on external tables be optimized?

Answer options

• A. Cluster the tables
• B. Create materialized views on the tables
• C. Use the metadata cache
• D. Enable the search optimization service

Correct answer: B

Explanation

Creating materialized views (option B) allows for pre-computed results, which significantly speeds up query performance on external tables. Clustering the tables (option A) and using the metadata cache (option C) may improve some aspects of query performance, but they do not provide the same level of optimization as materialized views. Enabling the search optimization service (option D) can help with search-related queries but is not specifically focused on external tables.