SnowPro Associate: Platform Certification
Validate foundational, entry-level understanding of the Snowflake Data Cloud platform, core multi-cluster shared data architecture, basic storage, virtual compute, and security concepts.
Official Exam Specification & Quick Facts
Question Difficulty Breakdown
Exam Guidelines & Simulation Rules
Frequently Asked Questions (FAQ)
The SnowPro Associate exam consists of 60-70 multiple-choice and multi-select questions over a 90-minute period. Registration costs $125 USD, with a passing scaled threshold of 70%.
Domains include: (1) Snowflake Architecture and Overview (~25%), (2) Virtual Warehouses and Compute (~25%), (3) Data Storage and Basic Loading (~25%), and (4) Security and Governance Basics (~25%).
Snowflake decouples storage, compute, and cloud services. Storage is centralized in cloud object storage, independent virtual warehouses scale compute on demand, and cloud services orchestrate metadata, security, and transactions.
A virtual warehouse is a cluster of independent compute resources (CPU, memory, temporary SSD) used to execute SQL queries, DML operations, and data loading tasks, billed per second with auto-suspend and auto-resume.
Snowflake automatically partitions all table data into immutable, encrypted micro-partitions (50 MB to 500 MB uncompressed) in columnar format, eliminating manual partitioning and index creation.
Zero-copy cloning creates a point-in-time copy of databases, schemas, or tables instantly by referencing existing metadata without duplicating the underlying physical storage blocks.
Time Travel enables querying, restoring, or cloning historical data that was modified or deleted, up to 1 day on Standard Edition and up to 90 days on Enterprise Edition and above.
Fail-Safe provides a non-configurable 7-day disaster recovery period following the Time Travel window, intended exclusively for Snowflake Support to recover historical data in case of catastrophic storage loss.
The `COPY INTO <table>` command performs bulk loading from internal or external cloud storage stages (Amazon S3, Azure Blob, Google Cloud Storage) into Snowflake tables.
Data Sharing enables live, direct sharing of database objects with other Snowflake accounts without copying, moving, or transferring data over the internet.
The SnowPro Associate credential is valid for two years from the pass date.
SnowPro Associate is designed for business analysts, junior data engineers, sales engineers, and beginners seeking proof of foundational Snowflake platform literacy before taking SnowPro Core.