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

Questions 6–10

1. 6application · medium

   A team runs a nightly transformation job on a Small warehouse. The job takes 30 minutes. They want to reduce the runtime to 15 minutes. The job is a single SQL statement that performs a large aggregation. What is the most direct way to achieve this?

   • AEnable multi-cluster scaling with a max cluster count of 2.
   • BSet the warehouse to auto-resume.
   • CScale up to a Medium warehouse.
   • DChange the scaling policy to standard.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   Which statement accurately describes the T-shirt sizes for Snowflake virtual warehouses?

   • AThe sizes range from X-Small to 4X-Large, with 4X-Large being 16 times X-Small.
   • BAll sizes have the same compute capacity but different storage limits.
   • CEach size doubles the compute capacity of the previous size.
   • DEach size increases compute capacity by 50% over the previous size.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A team currently runs a Large warehouse for a nightly ETL job. They estimate that the job uses only about 25% of the warehouse's capacity. They want to reduce cost while keeping the job's runtime acceptable. What should they do?

   • AKeep the Large warehouse but change the scaling policy to economy.
   • BScale down to a Medium warehouse and monitor the job's runtime.
   • CKeep the Large warehouse but enable multi-cluster scaling.
   • DScale up to an X-Large warehouse to ensure headroom.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   Which action would you take to make a virtual warehouse more powerful for a single complex query?

   • AIncrease the warehouse's storage capacity.
   • BChange the warehouse's scaling policy to economy.
   • CScale up the warehouse to a larger T-shirt size.
   • DScale out the warehouse by adding more clusters.
   Reveal Solution Discussion Select an answer first
6. 10expert · hard

   A team runs a warehouse that is sized as a Large. They notice that a query takes 30 seconds, and the query profile shows that the 'local disk spilling' step is the dominant cost. The warehouse's CPU utilization is low. What is the most likely cause and the best action?

   • AThe query is I/O-bound; optimize the query to scan less data.
   • BThe warehouse has too much concurrency; enable multi-cluster scaling.
   • CThe warehouse is over-provisioned; scale down to a Medium warehouse.
   • DThe query needs more memory than the warehouse provides; scale up to a 2X-Large warehouse.
   Reveal Solution Discussion Select an answer first