What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)
What strategies can be used to optimize the performance of a virtual warehouse? (Choose two.)
To optimize the performance of a virtual warehouse, reducing queuing helps manage and balance the workload effectively, preventing bottlenecks. Increasing the warehouse size can provide additional resources, allowing for faster processing of tasks and better overall performance.
AD is correct. Optimizing Warehouses for Performance: 1-Reduce queues (if WH is not multi cluster make it multi cluster else add another WH) 2-Resolve memory spillage ( scale up or convert it to Snowpark-optimized WH) 3-Increase warehouse size (Scale up) 4-Trying Query Acceleration - set ENABLE_QUERY_ACCELERATION = true 5-Optimizing the Warehouse Cache (by increasing Auto-suspension) 6-Limiting Concurrently Running Queries (Decrease the MAX_CONCURRENCY_LEVEL) https://docs.snowflake.com/en/user-guide/performance-query-warehouse
AD correct - https://docs.snowflake.com/en/user-guide/performance-query-warehouse