Welcome to this Course!1:20
Prepare for the SnowPro associate platform certification with practical hands-on experiments, concise concept reviews, two full practice exams, detailed explanations, quizzes, and comprehensive study materials.
About the SnowPro Platform Certification13:15
Explore the SnowPro associate platform certification for beginners, with a 65-question unproctored Snowflake exam, 85-minute limit, 75% passing, $100 fee, and focused study resources.
About your Instructor3:17
Meet Cristian Scutaru, former Snowflake data superhero and SnowPro SME with seven SnowPro certifications, including the platform exam, sharing hands-on experience, practice tests, and published courses.
How to Enjoy this Course4:24
Engage with hands-on SQL exercises and end-of-lecture slides to prepare for the SnowPro associate platform certification, using practice tests and cheat sheets to reinforce learning.
Frequently Asked Questions1:35

Introduction to Snowflake and the Architecture1:25
Explore the Snowflake architecture and hands-on concepts using the Snowsight web UI, Snowflake notebooks, and database objects, with a practical path via a free trial account.
1.1 Outline key features and benefits of the Snowflake AI Data Cloud9:17
Explore the Snowflake AI data cloud's elastic storage and compute with a decoupled architecture and elastic parallel processing for OLAP and hybrid OLAP/OLTP workloads.
1.2.1 Outline the key Snowflake user interfaces - Create a Free Trial Account4:24
Explore the Snowflake web UI, known as Snow Site, and learn to create a free 30-day Snowflake trial account with 400 USD of credits to practice in cloud data warehouse.
1.2.2 Outline the key Snowflake user interfaces - Snowsight Introduction14:47
Explore Snowsight, the Snowflake web UI, and discover key interfaces such as SQL and Python worksheets, notebooks, and the monitoring and query context features.
1.3 Describe how to use the Snowsight user interface14:57
Describe how to navigate the snowsight UI to create databases and schemas, load data from csv into a table using copy into, and manage stages and query history.
1.4 Work with Snowflake Notebooks12:52
Learn to work with Snowflake notebooks, manage sessions, run SQL or Python cells, and use Python variable substitution to pass data between cells and visualize results with Streamlit.
1.5 Describe Snowflake objects and how they fit into the Snowflake hierarchy12:31
Learn the Snowflake object hierarchy from account to schema, including databases, schemas, tables, views, stages, and data types like varchar, variant, and semi-structured data.
Test Your Knowledge

Introduction to Identity and Data Access Management0:44
Explore identity and data access management, focusing on users and roles, and differentiate object and global privileges while covering database schemas, metadata, and essential sql select clauses for the exam.
2.1.1 Define the roles that are used in Snowflake - Users and Roles12:22
Define snowflake roles and users, explain role based access control and role hierarchy, and demonstrate granting roles to users and to other roles to establish access.
2.1.2 Define the roles that are used in Snowflake - Access Privileges15:52
Explore how Snowflake uses roles to control access, privilege types, and object ownership. The lecture demonstrates granting and revoking privileges on warehouses, schemas, file formats, stages, views, and more.
2.2.1 Create a database, explore data, configure params etc - Database Schemas10:06
Learn to create and manage databases and schemas (including public schema), explore metadata with the information schema, configure parameters, transfer ownership, and navigate current session context in Snowflake.
2.2.2 Create a database, explore data, configure params etc - Run SQL Commands11:42
Explore basic sql querying with the select statement, focusing on exclude, select star, and limit variants such as top, offset, and fetch, using snowflake sample data.
Test Your Knowledge

Introduction to Data Loading and Virtual Warehouses1:14
Explore data loading and virtual warehouses, focusing on structured and semi-structured data like JSON, and learn Snowflake Cortex LLM functions and core data loading concepts for the exam.
3.1 Describe considerations on working with structured and semi-structured data20:31
Learn to load and query structured and semi-structured data, emphasizing JSON and stage usage. Distinguish fixed schema structured data from flexible semi-structured data and practical commands like copy into.
3.2 Explain virtual warehouses20:27
Explain virtual warehouses in Snowflake, including sizing, scaling (up, down, in, out), and the difference between standard and multi-cluster warehouses, plus auto suspend and auto resume for cost control.
3.3 Create tables in Snowflake and load data into the tables14:56
Learn to create and load tables in Snowflake using SnowSight, copy data into tables and stages, and preview table definitions and data with csv, json, and parquet formats.
3.4 Explain how to work with unstructured data12:01
Learn how to work with unstructured data in Snowflake by enabling a directory table on a stage, listing files with select statements, and generating file, scoped, and pre-signed URLs.
3.5 Explain how to use Snowflake Cortex LLM functions11:18
Learn how to call Snowflake Cortex LLM functions, including parse document, translate, classify text, and complete, for working with unstructured data like PDFs in the Snowflake AI data cloud.
Test Your Knowledge

Introduction to Data Protection and Data Sharing1:03
Explore data protection and secure data sharing concepts, including time travel, fail-safe, cloning and zero-copy cloning, as part of a 10% section, leading to Snowflake marketplace and data exchange.
4.1.1 Outline continuous data protection with Snowflake - Time Travel10:15
Discover continuous data protection in Snowflake by exploring time travel and cloning, including retention settings, at before queries, and fail safe details for safeguarding and recovering data.
4.1.2 Outline continuous data protection with Snowflake - Zero-Copy Cloning9:24
Outline continuous data protection with Snowflake using zero-copy cloning, where clones share initial data and store changes independently, aided by time travel and clone syntax for tables and other objects.
4.2.1 Define Snowflake data sharing capabilities - Secure Data Shares11:10
Define secure data sharing in Snowflake, detailing how to create outbound shares, grant privileges on views and functions, and provide inbound proxy databases for read-only access.
4.2.2 Define Snowflake data sharing capabilities - Marketplace and Data Exchange12:31
Learn Snowflake data sharing capabilities via marketplace and data exchange, including public and private shares, secure data sharing, and how to explore listings and data dictionaries.
Test Your Knowledge

Sample Questions with Answers11:24
Walk through five Snowflake exam-style questions with answers, covering data warehouse role, cloud services, show grants, warehouse size impact, and the cortex parse document function for SnowPro Associate exam prep.
Congratulations, You Made It!2:02
Prepare for the SnowPro Associate platform certification with two 65-question practice tests and a 75% passing score. Read explanations and references to push scores toward 90% on each attempt.
Full Practice Exam #1 (65 Questions)
Full Practice Exam #2 (65 Questions)
Bonus Lecture0:53

Requirements

Just some basic knowledge of the SQL language and relational databases
No prior knowledge of Snowflake required

Description

Who this course is for

People trying to pass the new SnowPro Associate: Platform certification exam issued recently by Snowflake.
Anyone trying to quickly get the easiest certification in Snowflake.
Beginners trying to acquire quickly an entry-level certification in SQL and data warehouses.
Anyone new to Snowflake AI Data Cloud, trying to learn and understand the basic concepts.
Entry-level Data Engineers and AI or ML Engineers with no prior knowledge of Snowflake.
Non-technical managers trying to get faster certified in Snowflake AI Data Cloud with the basic concepts.
This course may NOT be for you, if you already know Snowflake or are experienced enough in this area.

About your Instructor

My name is Cristian Scutaru and I’m a world-class expert in Snowflake, former SnowPro SME (Subject Matter Expert) and Snowflake Data Superhero.
For several years, I helped Snowflake create many of the exam questions out there. Many of the exam questions and answers from the SnowPro exams have been indeed created by me.
I passed over the years 7 SnowPro exams myself - including this one (with 95%) - all from the first attempt.
In the last 3-4 years alone, I passed over 40 paid proctored certification exams overall. And I still never failed one, I was lucky so far.

The course also contains TWO high-quality practice test with 65 exam-like questions each

All questions are closely emulated from those currently found in the actual SnowPro Associate: Platform certification exam.
All questions are curated and very similar to the actual SnowPro Platform exam questions.
Both practice exams are limited to 85 minutes, with a passing score of 75%, exactly like for the online unproctored exam.
All exam questions are rather short and test basic knowledge.
Detailed explanations with external references for any possible choice, in each practice test question.
Quiz question types are all multi-choice or multi-select.

Specifics of the real SnowPro Associate: Platform certification exam

announced on Feb 3rd, 2025
unproctored! (i.e. no camera, just an online exam with Pearson VUE)
entry-level and very basic, with no pre-requisites
65 questions
85 minutes time limit
75% passing score
$100 US fee per attempt
must renew after 2 years (auto-renewed by passing SnowPro Core)

What the exam will test you for

Setup and navigate the Snowflake user interface and Snowflake Notebooks.
Create database, stages, and use compute resources.
Load and leverage structured, semi-structured, and unstructured data.
Understand Snowflake roles, and data access management.
Understand and manage the Snowflake Account structure.
Call the Snowflake Cortex LLM functions.

What the typical candidate may have

Recommended 3+ months of knowledge with Snowflake.
Some very basic knowledge of the SQL language and relational databases.

Exam domain breakdown (from the Study Guide)

Interacting with Snowflake and the Architecture - 35%
Identity and Data Access Management - 15%
Data Loading and Virtual Warehouses - 40%
Data Protection and Data Sharing - 10%

[Disclaimer: We are not affiliated with or endorsed by Snowflake, Inc.]

Who this course is for:

Data Engineers with no prior knowledge of Snowflake
Anyone new to Snowflake willing to quickly acquire a basic certification
Non-technical managers willing to grasp basic Snowflake concepts

Training for the SnowPro Associate: Platform Certification

What you'll learn

Explore related topics

Course content

Introduction5 lectures • 24min

1.0 Interacting with Snowflake and the Architecture (35%)7 lectures • 1hr 10min

2.0 Identity and Data Access Management (15%)5 lectures • 51min

3.0 Data Loading and Virtual Warehouses (40%)6 lectures • 1hr 20min

4.0 Data Protection and Data Sharing (10%)5 lectures • 44min

Exam Practice Tests3 lectures • 14min

Requirements

Description

Who this course is for: