Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
Two users share a virtual warehouse named WH_DEV_01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?
To resolve performance issues when one user is loading data while another is querying data in a shared virtual warehouse, Snowflake recommends creating separate warehouses for each workload. This approach ensures that different operations, like data loading and querying, do not compete for the same compute resources, thereby improving overall performance.
Its best option refer the documentation
When you notice that a query is running slowly, check whether an overloaded warehouse is causing the query to compete for resources or get queued: If the running query load is high or there’s queuing, consider starting a separate warehouse and moving queued queries to that warehouse. Alternatively, if you are using multi-cluster warehouses, you could change your multi-cluster settings to add additional clusters to handle higher concurrency going forward. https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring.html#slow-query-performance
C from the video here : https://docs.snowflake.com/en/user-guide/warehouses-overview.html#
correct
If queries processed by a warehouse are running slowly, you can always resize the warehouse to provision more compute resources.
Should be C