SnowPro Core Certification — Question 714

What is a recommended approach for optimizing query performance in Snowflake?

Answer options

• A. Use subqueries whenever possible.
• B. Use a large number of joins to combine data from multiple tables.
• C. Select all columns from tables, even if they are not needed in the query.
• D. Use a smaller number of larger tables rather than a larger number of smaller tables.

Correct answer: D

Explanation

The correct answer is D because using fewer larger tables can enhance performance by reducing the overhead associated with managing many smaller tables. Options A, B, and C are less efficient as they can lead to increased complexity and resource consumption, negatively impacting query performance.