During the repair process, the warehouse starts processing SQL statements once 50% or more of the requested compute resources are successfully provisioned.

• A. 100%
• B. 75%
• C. 50%
• D. 25%

Answer: (C)

When a warehouse is being repaired, a balance is struck between keeping the system available and waiting for all resources to come online. The moment at which processing can start is when at least half of the requested compute capacity is provisioned. This 50% point provides enough parallel compute power to handle queries without forcing users to wait for every single resource to come online. Waiting for full provisioning (100%) would waste time and degrade availability, while starting with far less than half (like 25%) could leave the system underpowered for typical workloads. As additional resources finish provisioning, the warehouse can scale up to meet demand, but operation can begin as soon as half is ready.