Describe the Compute (virtual Warehouse) and Storage Layers COF-C03 Practice Questions (Page 5)

Questions 21–25

1. 21application · medium

   A startup uses Snowflake for a small analytics workload. They expect storage to grow significantly over time, but their query concurrency will remain low. They want to minimize costs. What architectural benefit of Snowflake should they rely on?

   • AStorage and compute scale independently, so they can keep a small warehouse while storage grows
   • BThey must scale the warehouse as storage grows to maintain performance
   • CStorage is automatically compressed, so they never need to worry about storage costs
   • DThey can use multi-cluster warehouses to automatically scale storage
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   What is the default state of a newly created virtual warehouse in Snowflake?

   • AResumed
   • BSuspended
   • CStarting
   • DDeallocated
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   A data analyst wants to estimate the monthly storage cost for a new table. They know the uncompressed data size is 1 TB. Snowflake automatically compresses data. What is the most accurate way to estimate the storage cost?

   • AUse the number of rows multiplied by a fixed byte size
   • BUse the uncompressed size plus 10% overhead for metadata
   • CUse the uncompressed size, because compression is not applied to tables
   • DUse the compressed size, which is typically smaller than the uncompressed size
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   How does automatic compression affect storage costs in Snowflake?

   • AIt shifts storage costs to compute costs
   • BIt has no effect on storage costs
   • CIt increases storage costs by adding overhead
   • DIt reduces the storage footprint, thereby lowering storage costs
   Reveal Solution Discussion Select an answer first
6. 25foundation · easy

   What is the purpose of a multi-cluster warehouse in Snowflake?

   • ATo provide high availability by replicating data across clusters
   • BTo reduce the cost of running queries by sharing resources
   • CTo increase the storage capacity of the warehouse
   • DTo automatically scale out and handle increased concurrent workloads
   Reveal Solution Discussion Select an answer first