Answer: Create separate warehouses for each workload

The question describes a scenario where two users sharing a warehouse experience performance issues when one loads data while the other queries. According to Snowflake documentation and best practices, when queries compete for resources on an overloaded warehouse, the recommended solution is to create separate warehouses for different workloads (loading vs querying). This prevents resource contention and ensures consistent performance. Option C aligns with Snowflake's guidance on workload isolation. Option A (scaling up) may provide temporary relief but doesn't address the fundamental issue of workload contention. Option B (separate warehouses per user) is inefficient and not the recommended approach. Option D (stopping concurrent operations) is impractical for business operations. The community discussion shows strong consensus for C (73% of answers) with multiple references to Snowflake documentation supporting this approach.

Author: LeetQuiz Editorial Team