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

Questions 16–20

1. 16foundation · easy

   What type of storage does Snowflake use for its storage layer?

   • AA proprietary database file system managed by Snowflake
   • BA network-attached storage (NAS) appliance
   • CCloud-based object storage provided by the underlying cloud provider
   • DLocal SSD attached to each virtual warehouse
   Reveal Solution Discussion Select an answer first
2. 17application · easy

   A company is evaluating Snowflake's architecture for a new data platform. They want to understand how storage is managed. Which statement accurately describes Snowflake's storage layer?

   • AStorage is managed by the virtual warehouse and scales with the warehouse size
   • BStorage is a separate, scalable, and durable cloud-based object storage system
   • CStorage is only accessible when a warehouse is running
   • DStorage is stored on local disks attached to each warehouse node
   Reveal Solution Discussion Select an answer first
4. 18expert · hard

   A data engineer is tuning a query that filters on a column with high cardinality. The table is large and queries are slow. They notice that the query scans many micro-partitions. What is the most effective way to reduce the number of micro-partitions scanned?

   • AIncrease the warehouse size
   • BUse Time Travel to access an older version of the table
   • CEnable multi-cluster on the warehouse
   • DCluster the table on the filter column
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A company runs a mix of short, frequent queries and a few long-running reports. They currently use a single Large warehouse. The short queries are often delayed because the long reports consume all the compute. They want to improve performance for the short queries without significantly increasing overall credit consumption. What is the best approach?

   • AEnable multi-cluster on the Large warehouse with max clusters set to 5
   • BSet auto-suspend to 1 minute on the Large warehouse
   • CCreate a separate warehouse for the long reports and keep the Large warehouse for short queries
   • DIncrease the warehouse size to X-Large
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A company uses a Snowflake warehouse for ad-hoc analytics. To control costs, they set auto-suspend to 60 seconds and auto-resume to enabled. A user runs a query at 9:00 AM, and the warehouse was suspended. What happens when the query is submitted?

   • AThe warehouse resumes, but the query is queued until the next auto-suspend cycle
   • BThe warehouse resumes automatically and the query runs after a brief startup delay
   • CThe query fails because the warehouse is suspended
   • DThe user must manually resume the warehouse before running the query
   Reveal Solution Discussion Select an answer first