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

Questions 21–23

1. 21application · medium

   A company has a virtual warehouse that serves a BI dashboard used by 50 analysts. During peak hours, queries queue up and wait times exceed 30 seconds. The warehouse is currently a single-cluster Medium. The team wants to reduce wait times without changing the warehouse size. Which configuration should they implement?

   • ASet the scaling policy to economy.
   • BIncrease the warehouse size to Large.
   • CEnable multi-cluster scaling with a max cluster count of 3 and standard policy.
   • DSet the warehouse to auto-suspend after 1 minute.
   Reveal Solution Discussion Select an answer first
2. 22expert · hard

   A data team runs a mix of workloads on a single Medium warehouse: short BI queries, long-running ETL jobs, and occasional ad-hoc analytics. They notice that the ETL jobs are slow, but the BI queries are fast. The query profile for the ETL jobs shows high CPU utilization and some disk spilling. What is the best course of action?

   • AScale up the Medium warehouse to a Large warehouse for all workloads.
   • BChange the scaling policy to economy.
   • CCreate a separate, larger warehouse for the ETL jobs and keep the Medium warehouse for BI queries.
   • DEnable multi-cluster scaling on the Medium warehouse.
   Reveal Solution Discussion Select an answer first
3. 23foundation · easy

   What is the compute capacity of a Medium virtual warehouse compared to an X-Small?

   • A2 times
   • B16 times
   • C4 times
   • D8 times
   Reveal Solution Discussion Select an answer first