Size and Scale Virtual Warehouses COF-C03 Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A team has a multi-cluster warehouse with a min cluster count of 1 and a max cluster count of 3. They want to ensure that during a predictable daily peak, the warehouse has at least 2 clusters available immediately, without waiting for the scaling policy to add them. What should they configure?

   • ASet the warehouse to auto-resume.
   • BChange the scaling policy to standard.
   • CIncrease the max cluster count to 5.
   • DSet the min cluster count to 2.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which scaling policy for a multi-cluster warehouse prioritizes minimizing query latency over cost?

   • AStandard
   • BManual
   • CEconomy
   • DAuto
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A team runs a multi-cluster warehouse with a max cluster count of 4. Each cluster is sized as a Medium. They want to increase the total compute capacity of the warehouse without changing the number of clusters. What should they do?

   • AIncrease the max cluster count from 4 to 8.
   • BChange the scaling policy from standard to economy.
   • CIncrease the warehouse size from Medium to Large.
   • DSet the min cluster count to 4.
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A team has a multi-cluster warehouse with a min cluster count of 1 and a max cluster count of 4. They use the standard scaling policy. During a peak period, they notice that the warehouse is running at 4 clusters and queries are still queuing. What is the most likely reason?

   • AThe warehouse size is too small; scale up to a larger size.
   • BThe max cluster count is too low for the concurrency demand.
   • CThe min cluster count is too low; increase it to 4.
   • DThe scaling policy is too aggressive; change to economy.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A Snowflake administrator notices that a Medium warehouse frequently shows high CPU utilization and queries are taking longer than expected. The query profile for the slowest queries shows significant time spent in the 'local disk spilling' step. What does this indicate, and what is the most appropriate action?

   • AThe warehouse is correctly sized; enable multi-cluster scaling.
   • BThe warehouse is correctly sized; the issue is network latency.
   • CThe warehouse is over-provisioned; scale down to a smaller size to reduce cost.
   • DThe warehouse is under-provisioned for the workload; scale up to a larger size.
   Reveal Solution Discussion Select an answer first