SOL-C01 Question #162: Real Exam Question with Answer & Explanation

Question

You have created a virtual warehouse in Snowflake and loaded data into several tables. You observe that query performance is inconsistent, with some queries running quickly and others taking significantly longer, even though they access similar data. You suspect resource contention is the issue. What steps can you take to improve query performance and manage resource contention effectively? Select all that apply.

Options

• AIncrease the size of the virtual warehouse to provide more computing resources.
• BEnable query acceleration to offload suitable workloads and reduce warehouse load.
• CCreate separate virtual warehouses for different workloads (e.g., data loading, reporting) to isolate
• DImplement workload management rules to prioritize critical queries and limit resource consumption
• EReduce the number of concurrent users accessing the system.

Explanation

Options A, B, C, and D are all valid strategies for improving query performance and managing resource contention. Increasing warehouse size (A) provides more resources. Query Acceleration Service(B) can significantly reduce latency for eligible queries and reduce overall warehouse load. Separate warehouses (C) isolate workloads. Workload management (D) allows prioritizing critical queries and limiting resources for others. Option E, while it might alleviate contention, is not a scalable solution and limits usability; better resource management is preferred.

No community discussion yet for this question.