SnowPro Core Certification Guide
Preparation, checks and hints needed to clear SnowPro Core Certification in your 1st attempt
To begin with SnowPro Core Certification is a simple exam if you are already working on Snowflake in any capacity.
Incase if you are new to Snowflake, get self started by referring to — https://snowflakewiki.medium.com/snowflake-get-self-started-6859d4f2112c
Important for Preparation -
Visit the SnowPro Core Certification Exam Guide — https://learn.snowflake.com/courses/course-v1:snowflake+CERT-SPC-GUIDE+A/about?_ga=2.234095838.1541219588.1647157808-1471695939.1646832664
Give the special attention to the following. (Note — It can get changed from time to time) -
Total Number of Questions
Question Types
Time Limit
Then go through each and every topic that is mentioned in the Exam Domain section (Note — It can get changed from time to time). Just get the understanding of the topic or the term from the snowflake documentation and note the key words and pointers.
Ex: Lets consider -
1.0 Domain: Account and Security
1.1 Explain how to manage Snowflake accounts.
Account usage
Information schema
As part of preparation you should understand — What is Account Usage? What is Information schema? When and in what scenarios do we use them? What is the difference between them?
Snowflake documentation answers all your such questions.
Cheat Sheet -
Attached is the cheat sheet by Jeno Yamma for your quick revision.
https://www.slideshare.net/JenoYamma/snowflake-snowpro-certification-exam-cheat-sheet
Note of caution using it: The content in the cheat sheet can become stale and advice you to create one from snowflake documentation as you go with preparation.
Flashcards -
Below Quizlet and Quiz can aide in quiz revision for snowpro core exam as they test the basic knowledge across the certification topics -
https://quizlet.com/380510774/flashcards
https://www.proprofs.com/quiz-school/story.php?title=sw_561x2
Note of caution using them: The content can become stale and answers can be wrong and request to refer to snowflake documentation in case of doubt.
Special Tips -
Give special focus to numbers and default options which you are most likely to get confused during the exam such as -
What is the size of each micro partition with compression and with out compression?
What is the size imposed on VARIANT data type?
What is the recommended file size for data loading? Is it with compression and with out compression?
What is the default file size for unloading data? with compression and with out compression?
What are the Time-Travel and Fail Safe days for different tables and accounts with default options?
What is the default scaling policy for warehouse?
What is the default file format supported by copy command?
What is the default ON_ERROR copy option?
What is the default role given to a newly created user?
Exam Day Tips -
- Don’t get stuck and flag the questions you may be confused during the exam and proceed further. Many a case, you can get hint in the following questions asked during the certification.
- If you are left with time, do revisit all the questions and cross check your answers (especially the multiple choice ones)
Good luck for exam and get Snowed!
References: https://www.snowflake.com/
Clap if you like the content and follow me for more such content. Feel free to ask if you have any questions in the comments. I will be more than happy to assist and guide you.
