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

Questions 11–15

1. 11foundation · easy

   What does the separation of storage and compute in Snowflake enable?

   • AData must be stored in the same region as compute.
   • BStorage and compute must be scaled together.
   • CCompute resources can be scaled independently of storage.
   • DQueries can only run when storage is scaled up.
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A company has a large, static dataset that is queried infrequently. They want to minimize costs while keeping the data available for occasional analysis. How does Snowflake's separation of storage and compute help achieve this?

   • AThey can load the data into a virtual warehouse to avoid storage costs.
   • BThey must keep a virtual warehouse running at all times to ensure the data is accessible.
   • CThey can move the data to a cheaper storage tier, which is the only way to reduce costs.
   • DThey can keep the data in storage and only start a virtual warehouse when a query needs to run.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   How does Snowflake support secure data sharing between accounts?

   • ABy creating a public link to the data.
   • BBy exporting data to a shared cloud storage bucket.
   • CBy copying data to the consumer's storage.
   • DBy providing access to the data through the services layer without copying it.
   Reveal Solution Discussion Select an answer first
5. 14foundation · easy

   In Snowflake's multi-cluster shared data architecture, which statement best describes the relationship between the storage, compute, and services layers?

   • AStorage and compute are combined into one layer, while services run separately.
   • BCompute and services are combined into one layer, while storage is external to the platform.
   • CAll three layers are tightly coupled and must be scaled together as a single unit.
   • DStorage, compute, and services are separate layers that communicate over a shared metadata store.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   In Snowflake's storage layer, how is data physically organized?

   • AIn a single large file that is shared across all virtual warehouses.
   • BIn compressed, columnar format that is optimized for analytical queries.
   • CIn row-oriented files that are optimized for transactional workloads.
   • DIn unstructured blobs that require external tools to query.
   Reveal Solution Discussion Select an answer first