Snowflake: SnowPro core certification in 100 Hrs

CloudSatya By Satya
2 min readJan 9, 2022

I am having 15+ years IT experience majorly into database and Data warehousing technologies working as Cloud Solution Architect.

With increasing demand of Snowflake and multiple RFPs to worked on snowflake, I decided to appear for snopro certification.

Below are details of study approach:

Snowflake exam guide

Udemy courses

Snowflake documentation and level up series

Hands-on trial account along with courses

Prep Tests

Final Notes

  1. All details for snopro core exam will be available here:

2. udemy course links

https://www.udemy.com/course/snowflake-masterclass/

https://www.udemy.com/course/snowflake-essentials/

https://udemy.com/course/snowflake-zero-to-hero-masterclass/

Please make sure you create trial accounts (free for 30 days)while doing these courses to try maximum labs and hands-on.

3. Snowflake documentation is most important and critical one. (You might see many answers in practice tests are wrong so need to get confirmed from snowflake documentation).

Learn.snowflake.com has many LEVEL UP series courses.

eg.

Also earn Below badges

4. You can create trial account and try all important features e.g.

sharing

cloning

warehouse creation

resource monitors

Tasks

Streams

Pipes

snowSql

snowCD

UDF

Stored procedures

loading and unloading using put,get,copy

5. prep tests links :

https://www.udemy.com/course/snowflake-practice-tests-for-snopro-core-certification/learn/quiz/5570156#overview

https://www.udemy.com/course/snowflake-snowpro-core-certification-practice-exams/

https://www.udemy.com/course/snowflake-snowpro-core-certification-exam-practice-sets/

https://www.udemy.com/course/snowflake-practice-tests-for-snopro-core-certification/learn/quiz/5570156#overview

https://www.udemy.com/course/snowflake-certification-preparation/

https://www.udemy.com/course/snowpro-core-certification-mock-tests/

whizlabs.com Snowflake 2 practice tests

While going through courses and prep tests, create notes with all important points and revise time to time before giving new practice tests.

some quick recap to questions appeared in exam today:

i.Snowflake Editions for different features

ii.Loading and unloading file types and methods (get/put/copy)

iii.Snowflake layers and its features

iv. Caching types and its functions

v. cloning features

vi. Snowflake ecosystem tools like datarobot,alation,dbt

vii.information schema and account usage

100 hours you can divide into major components

udemy courses : 20–25 hrs

6 prep tests : 20–25 hrs

level up and snowflake documentation : 18–20 Hrs

Snowflake notes creation:4–5 hrs

Trial account and hands on : 20 hrs

Revision : 4–5 Hrs

other readings on internet/Medium article's/cheat sheet : 4–5 hrs

cheat sheet (take printout for quick reference) : https://servian.dev/snowflakes-snowpro-certification-exam-preparation-guide-how-to-pass-in-3-days-5e5baa484c68

Video series by snowflake data hero by Jyoce :

--

--

CloudSatya By Satya

AWS certified solution Architect and Data Analytics Specialty certified