SnowPro Core study guide
SnowPro Core · Work through your exam, one topic at a time.
The SnowPro Core Certification is Snowflake's foundational credential for practitioners who build, secure, and operate workloads on the Snowflake AI Data Cloud. It suits data engineers, analytics engineers, database administrators, data architects, and analysts who already work hands-on with Snowflake and want an objective benchmark of core platform knowledge, and it is commonly used by teams as a baseline before moving on to role-specific specializations. The SnowPro Core study guide has 5 sections and about 1,957 words.
01Snowflake AI Data Cloud Features and Architecture
Snowflake's architecture separates storage (cloud object storage holding micro-partitions), compute (virtual warehouses), and cloud services (metadata, optimizer, transactions, security, authentication). Micro-partitions are immutable, columnar, compressed units of roughly 50–500 MB of uncompressed data.
282 words, about 1 min02Account Access and Security
Snowflake applies discretionary access control on top of role-based access control. A privilege (USAGE, SELECT, INSERT, CREATE TABLE, OWNERSHIP…) is granted on a securable object (database, schema, table, warehouse) to a role ; roles are granted to users and to other roles.
351 words, about 2 min03Performance Optimization, Querying, and Data Transformation
Almost all Snowflake tuning reduces bytes scanned . Because every micro-partition stores min/max metadata per column, the optimizer prunes partitions that cannot match a filter.
604 words, about 3 min04Data Loading and Unloading
Snowflake loads through stages . A user stage ( @~ ) is private to one user, a table stage ( @%table name ) is tied to a table and usable by anyone with INSERT rights, and a named stage (internal @my stage , or external pointing at S3/Azure/GCS) is a database object you can grant privileges on.
364 words, about 2 min05Data Protection and Data Sharing
AT(OFFSET = -3600) or BEFORE(STATEMENT = ...) , plus UNDROP TABLE/SCHEMA/DATABASE . Retention is 0–1 day on Standard and up to 90 days on Enterprise, configurable per table with DATA RETENTION TIME IN DAYS .
356 words, about 2 min