SOL-C01 · Question #162
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 significa
Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #162. The question stem and answer options stay visible for context.
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.
Unlock SOL-C01 to see the answer
You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.