How can a user improve the performance of a single large complex query in Snowflake?

The correct answer is A. Scale up the virtual warehouse. Scaling UP means increasing the size of the virtual warehouse (e.g., from Small to Medium or Large), which provides more CPU and memory resources to execute a single complex query faster. Scaling OUT (adding more clusters via multi-cluster warehouses) improves concurrency for…

Performance Management

Question

Options

AScale up the virtual warehouse.
BScale out the virtual warehouse.
CEnable standard warehouse scaling.
DEnable economy warehouse scaling.

How the community answered

(27 responses)

A
96% (26)
D
4% (1)

Explanation

Scaling UP means increasing the size of the virtual warehouse (e.g., from Small to Medium or Large), which provides more CPU and memory resources to execute a single complex query faster. Scaling OUT (adding more clusters via multi-cluster warehouses) improves concurrency for many simultaneous users/queries, not single-query performance. Economy and Standard scaling modes control how multi-cluster warehouses auto-scale for concurrency, not single-query speed.

Topics

#Virtual Warehouses#Query Performance#Warehouse Scaling#Compute Resources

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice