SnowPro Core study plan
SnowPro Core · Give each week a clear focus.
8 weeks · About 7 hours per week
Snowflake AI Data Cloud Features and Architecture
Diagram the Snowflake architecture layers (storage, compute, cloud services) and explain in writing how each layer scales independently
Build a trial account and provision three virtual warehouse sizes, then compare credit burn and query latency on the same 50-row and 50-million-row query
Describe the database/schema/table object hierarchy and create a working example of each object type
Explain micro-partitioning and columnar storage well enough to predict why a point-lookup query scans less data than a full-table aggregate
Your checkpoint
A one-page architecture cheat sheet plus a screenshot log of the warehouse-size experiment with measured credit usage
Snowflake AI Data Cloud Features and Architecture & Account Access and Security
Compare Snowflake editions and list which features (Time Travel length, masking, replication) unlock at each tier
Create a role hierarchy with three custom roles and one functional role, then verify inherited privileges with a query against the grants views
Summarize how the cloud services layer handles metadata, query parsing, optimization, and access control
Distinguish between virtual warehouse caching, results caching, and metadata caching, and state when each is invalidated
Your checkpoint
A role-hierarchy diagram plus a saved worksheet of GRANT statements that reproduces it from scratch
Performance Optimization, Querying, and Data Transformation
Diagnose a slow query using the query profile, identifying pruning, spilling, and exploding-join symptoms
Apply the clustering key to a large table and measure the change in partitions scanned before and after
Tune warehouse size and multi-cluster settings against a concurrency workload and record the tradeoffs
Read a query plan and explain when the optimizer prunes, filters, or rewrites a join
Your checkpoint
A before/after performance report for three queries with partitions-scanned and execution-time numbers
Performance Optimization, Querying, and Data Transformation
Write queries using window functions, QUALIFY, and common table expressions to solve ranking and de-duplication problems
Transform semi-structured JSON with VARIANT, FLATTEN, and dot/bracket path notation
Implement a Type 2 slowly changing dimension or an incremental aggregate using streams and tasks
Explain how Snowpark, UDFs, and stored procedures extend SQL transformation inside Snowflake
Your checkpoint
A library of 10 saved transformation queries, each annotated with the scenario it solves and the output it produces
Data Loading and Unloading
Load CSV and JSON files from an internal stage using COPY INTO with a defined file format and error-handling options
Configure an external stage backed by cloud storage and validate connectivity with a LIST command
Debug a failed load by inspecting the COPY history and the rejected-records output
Load data with schema evolution or a transformation clause without a separate staging table
Your checkpoint
An end-to-end load script that ingests three file formats into a raw schema and reports row counts plus rejected rows
Data Loading and Unloading
Unload query results to an external stage in Parquet and CSV with COPY INTO and verify the file layout
Set up Snowpipe for continuous ingestion and confirm near-real-time loading with a file-drop test
Compare bulk COPY, Snowpipe, and Snowpipe Streaming on latency, cost, and setup complexity
Apply file sizing, compression, and partitioning practices that minimize load time and cost
Your checkpoint
A runbook documenting ingestion and unload patterns with a Snowpipe latency measurement from a timed file drop
Data Protection and Data Sharing & Account Access and Security
Implement Time Travel and Fail-safe policies and recover a dropped table and a modified table with the correct syntax for each case
Clone a database and a schema, then prove that the clone is zero-copy by comparing storage usage
Create a secure data share with a secure view, and contrast a direct share with a reader account
Configure a network policy, MFA enforcement, and a masking policy, then verify each blocks the intended access path
Your checkpoint
A recovery-and-sharing lab write-up showing the restore statements, the clone verification query, and a diagram of the share consumers
Account Access and Security & Data Protection and Data Sharing & Performance Optimization, Querying, and Data Transformation
Review replication and failover concepts for cross-region business continuity
Re-audit weak domains using missed-question tags from prior weeks and rewrite notes for each gap
Complete a timed 100-question practice set under exam conditions
Re-teach your three weakest topics aloud from memory without notes
Your checkpoint
A scored practice exam (target 80% or higher) with a written error log naming the root cause for every missed question
Milestones
Week 2: Can explain storage/compute separation and reproduce a working role hierarchy from memory without referencing notes
Week 4: Can read a query profile and name the specific fix for spilling, poor pruning, and exploding joins in under five minutes each
Week 6: Can build a stage-to-table pipeline and a table-to-stage unload from a blank worksheet in one sitting
Week 8: Scored 80% or higher on a full-length timed practice exam and closed every gap in the error log