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

Questions 1–5

1. 1foundation · easy

   Which statement best describes the relationship between a virtual warehouse and the storage layer in Snowflake?

   • AThe warehouse accesses data from the storage layer to process queries
   • BThe warehouse stores data locally and the storage layer provides backups
   • CThe warehouse and storage layer are combined into a single service
   • DThe storage layer provides compute resources for the warehouse
   Reveal Solution Discussion Select an answer first
2. 2expert · hard

   A company runs a warehouse for 8 hours a day. They are considering using a multi-cluster warehouse with min clusters = 1 and max clusters = 3 to handle occasional spikes. They want to estimate the maximum possible credit consumption per day. What is the maximum credits the warehouse could consume in a day?

   • AIt depends on the warehouse size
   • B16 credits
   • C8 credits
   • D24 credits
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is a micro-partition in Snowflake?

   • AA temporary cache used by virtual warehouses
   • BA logical grouping of tables for performance optimization
   • CA type of index used to speed up queries
   • DA small unit of data storage that is immutable and contains a subset of table rows
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which characteristic is a key benefit of Snowflake's storage layer being separate from compute?

   • AStorage costs are included in the warehouse billing
   • BQueries run faster because data is stored in memory
   • CStorage can be scaled independently of compute resources
   • DData is automatically replicated to multiple cloud providers
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A company clones a production table to create a development copy. After a week, they make significant changes to the development copy. They want to understand the storage cost impact. What is the most accurate statement?

   • AThe clone always uses the same storage as the original, so no additional storage is ever incurred
   • BThe clone initially shares storage with the original, but as changes are made, additional storage is consumed for the new micro-partitions
   • CThe clone's storage cost is based on the original table's size, not the changes
   • DThe clone immediately duplicates all data, doubling storage costs
   Reveal Solution Discussion Select an answer first