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

Question

A data engineer is experiencing inconsistent query performance during peak hours. They have a single X- Small warehouse currently configured. After analyzing query history, they observed significant queuing delays. Which of the following actions would MOST effectively address this performance issue while minimizing costs in the short term?

Options

• AUpgrade the warehouse size to Large. This will provide more resources to handle concurrent
• BEnable auto-suspend on the warehouse to reduce credits consumed during idle periods.
• CEnable auto-resume on the warehouse to ensure it's always available.
• DEnable multi-cluster warehouse with a minimum and maximum cluster count of 2. This will scale
• ECreate a separate X-Small warehouse for each user to isolate their workloads.

Explanation

Enabling a multi-cluster warehouse allows Snowflake to automatically scale out compute resources by adding additional clusters as needed to handle concurrent queries and reduce queuing. Upgrading the warehouse size (option A) is more expensive and might not be the most cost-effective initial solution. Auto-suspend/resume (options B & C) do not address concurrency issues. Creating separate warehouses per user (option E) adds administrative overhead and may not be efficient if users have varying workload demands.

No community discussion yet for this question.