Skip to content

Certifications / SnowPro Core / Study plan

Study plan

Every objective in the published exam guide, grouped by exam section and ordered the way the guide orders them.

0 answered correctly0 not correct, still open19 not tried yet0 of 19 objectives tried

This is a record of what you have tried, not a score and not a prediction of the real exam.

Start hereStudy noteSnowflake AI Data Cloud Features and Architecture

How Snowflake's layered architecture separates storage, compute, and services

Objective 1 of 6 in Snowflake AI Data Cloud Features and Architecture, the first section in the guide. Not tried yet. See all 5 exam sections

What this note covers

Snowflake uses a unique multi-cluster shared data architecture that combines elements of shared-disk and shared-nothing architectures. It consists of three independently scalable layers: database storage, query processing (virtual warehouses), and cloud services. This design allows storage and compute to scale independently, enabling elastic performance and concurrency.

The facts the exam tests

  • The storage layer holds all data in compressed, columnar, micro-partitioned format in cloud storage (S3, Azure Blob, or GCS), fully managed and optimized by Snowflake.
  • The compute layer consists of virtual warehouses (MPP clusters) that independently process queries; multiple warehouses can access the same data simultaneously without contention.
  • The cloud services layer handles authentication, metadata management, query parsing/optimization, security, and infrastructure management, coordinating across the entire system.
  • Virtual warehouses can be resized, suspended, resumed, or set to auto-suspend/auto-resume, and multi-cluster warehouses can scale out automatically to handle concurrency spikes.
  • Because compute and storage are separated, you only pay for storage used and compute time consumed, and scaling one does not require scaling the other.
  • Snowflake runs natively on AWS, Azure, and GCP, and its architecture allows for seamless cross-cloud and cross-region features like replication without changing the underlying data model.
Check this objectiveFree · always available

A Snowflake Practitioner manages a shared table where the ETL team loads data using WH_LOAD and the BI team runs dashboard queries using WH_BI. During month end, ETL loads on WH_LOAD slow down whenever BI users issue large scans on WH_BI. The requirement is that neither team's workload should compete for the same compute resources, and the table data must not be duplicated across teams. Which architectural principle allows this separation?

The 5 exam sections

Ordered as the guide orders them

Snowflake AI Data Cloud Features and Architecture31% of the exam0 of 6 tried
Account Management and Data Governance20% of the exam0 of 3 tried
Data Loading, Unloading, and Connectivity18% of the exam0 of 3 tried
Performance Optimization, Querying, and Transformation21% of the exam0 of 4 tried
Data Collaboration10% of the exam0 of 3 tried

These are independent practice questions, written against this certification's published exam guide. They are not the certification vendor's own questions, and not the real exam.