Describe Snowflake's Multi-Cluster Shared Data Architecture COF-C03 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the purpose of automatic caching in Snowflake?

   • ATo improve query performance by reusing results of previously executed queries.
   • BTo ensure data is backed up automatically.
   • CTo reduce storage costs by storing data in memory.
   • DTo synchronize data between different regions.
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   How does the separation of storage and compute contribute to cost efficiency?

   • AYou are charged for storage only when queries are running.
   • BYou pay for storage and compute together as a single unit.
   • CYou must keep compute running at all times to access data.
   • DYou can scale compute up or down based on demand, paying only for what you use.
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A data engineer is explaining to a colleague why Snowflake can store petabytes of data while only paying for the storage used, independent of the compute resources. Which layer of Snowflake's architecture is responsible for this capability?

   • AThe centralized storage layer, which stores all data in a compressed, columnar format.
   • BThe virtual warehouse layer, which provides compute resources.
   • CThe cloud provider's object storage, which is used for temporary staging of query results.
   • DThe services layer, which manages metadata and query optimization.
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which characteristic is true of Snowflake's storage layer?

   • AIt is centralized and scalable, holding all data in a compressed, columnar format.
   • BIt stores data in an uncompressed format to simplify access.
   • CIt is limited to a fixed size and cannot grow beyond that.
   • DIt is managed by each virtual warehouse independently.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   An organization has a virtual warehouse configured to auto-suspend after 5 minutes of inactivity. A user runs a query, and after it completes, the warehouse suspends. Another user then runs a new query. What happens?

   • AThe new query triggers the warehouse to resume automatically, and the query is processed.
   • BThe new query is processed by the services layer without needing a virtual warehouse.
   • CThe new query fails because the warehouse is suspended.
   • DThe new query is queued until the warehouse is manually resumed by an administrator.
   Reveal Solution Discussion Select an answer first