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

Questions 6–10

1. 6foundation · easy

   How does the separation of compute and storage improve concurrency in Snowflake?

   • AIt automatically increases the size of the warehouse
   • BIt allows queries to run without any compute resources
   • CMultiple virtual warehouses can access the same data concurrently without interfering with each other
   • DIt eliminates the need for virtual warehouses
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   How does increasing the size of a virtual warehouse affect query performance?

   • AIt increases the compute resources available for each query
   • BIt automatically increases the number of concurrent queries that can run
   • CIt decreases the latency of network communication with the storage layer
   • DIt reduces the amount of data stored in the warehouse
   Reveal Solution Discussion Select an answer first
4. 8expert · hard

   A company has a warehouse that is used for both interactive dashboards and heavy batch processing. The dashboards need fast response times, while the batch jobs can tolerate longer runtimes. They want to optimize performance and cost. What is the best approach?

   • AUse a multi-cluster warehouse with max clusters set to 10
   • BUse a single large warehouse for both workloads
   • CSet auto-suspend to 1 minute to reduce costs
   • DCreate two warehouses: a small one for dashboards and a larger one for batch jobs
   Reveal Solution Discussion Select an answer first
5. 9application · medium

   A development team wants to create a full copy of a production table to use for testing. They want to minimize storage costs and avoid duplicating the underlying data. Which Snowflake feature should they use?

   • ACREATE VIEW over the table
   • BEXPORT the table to a stage and re-import
   • CCREATE TABLE AS SELECT (CTAS)
   • DCREATE CLONE of the table
   Reveal Solution Discussion Select an answer first
6. 10foundation · easy

   How does Snowflake's cloning feature avoid duplicating data?

   • AIt creates a copy of the data in a different cloud region
   • BIt copies only the metadata, not the data
   • CIt creates a new table that shares the underlying micro-partitions until changes are made
   • DIt uses compression to reduce the size of the copy
   Reveal Solution Discussion Select an answer first