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

Questions 1–5

1. 1foundation · easy

   What is the primary purpose of a multi-cluster virtual warehouse?

   • ATo handle higher concurrency by adding more clusters.
   • BTo reduce storage costs by distributing data.
   • CTo increase the compute power of each server.
   • DTo provide data redundancy for high availability.
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A data engineering team runs a daily batch transformation job that loads data into a reporting table. The job currently runs on an X-Small warehouse and completes in 45 minutes, but the business requires it to finish within 20 minutes. The job is a single, long-running SQL statement that cannot be parallelized across statements. Which action should the team take?

   • ASet the warehouse to auto-suspend after 5 minutes of inactivity.
   • BChange the scaling policy from standard to economy.
   • CEnable multi-cluster scaling with a max cluster count of 4.
   • DIncrease the warehouse size from X-Small to Medium.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which tool or feature in Snowflake provides detailed information about the execution steps of a specific query?

   • AQuery Profile
   • BResource Monitor
   • CAccount Usage views
   • DWarehouse Load History
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   What is the primary trade-off of using the economy scaling policy?

   • AIt cannot be used with multi-cluster warehouses.
   • BIt uses more credits than standard policy.
   • CIt may result in higher query latency during load spikes.
   • DIt automatically scales down to zero clusters when idle.
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A Snowflake administrator is investigating a performance issue on a Medium warehouse. The query profile for a slow query shows that the 'remote disk I/O' step is the dominant cost, and the warehouse's CPU utilization is low. What is the most likely cause and the best action?

   • AThe warehouse is under-provisioned; scale up to a Large warehouse to reduce I/O.
   • BThe query is I/O-bound; scaling up to a Large warehouse will not help much, so consider optimizing the query or using clustering keys.
   • CThe warehouse is over-provisioned; scale down to a Small warehouse.
   • DEnable multi-cluster scaling to distribute the I/O across clusters.
   Reveal Solution Discussion Select an answer first