SnowPro Core Certification — Question 426

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?

Answer options

• A. Scale up the existing warehouse
• B. Create separate warehouses for each user
• C. Create separate warehouses for each workload
• D. Stop loading and querying data at the same time

Correct answer: C

Explanation

The correct answer is C because creating separate warehouses for each workload allows for independent scaling and resource allocation, thus minimizing performance impacts. Options A and B may not effectively address the performance issues as they do not isolate the workloads, while option D is not practical for ongoing operations.