Here a small guide for people interested to pass the exam of SnowPro core certification.
The 2 hours, 100 questions exam tests an individual’s foundational and advance knowledge of Snowflake in the following areas :
- Snowflake Architecture
- Snowflake Interface and connectivity
- Data Loading
- Data Unloading
- Semi-Structured Data
- Security and access
- Data Sharing
- Performance and Tuning
To pass the exam, you need minimum 80% ( 80 correct responses from 100 ) and the duration will be 2 hours.
For my personal experience, I have one year of experience using Snowflake, plus I spent 5 days preparing for the exam, I used mainly the mindtickle university website to go through all videos. Link here
In addition to that, i found this blog, well documented for last minute review before the exam, it encapsulate all the details about the areas covored : https://medium.com/weareservian/snowflakes-snowpro-certification-exam-preparation-guide-how-to-pass-in-3-days-5e5baa484c68
The SnowPro ™ Core Certification demonstrates an individual’s knowledge to apply specific core expertise implementing and migrating to Snowflake. A SnowPro ™ Core Certified individual has a thorough understanding of Snowflake as a cloud data warehouse and has the knowledge necessary to design, develop and manage secure, scalable Snowflake solutions to drive business objectives
Example of questions that could be asked are generic multi-answer ( one or multi choice ) or yes / no questions.
Question 1 : What are the data type supported by variant :
Question 2 : Can Data Share be done between regions ?
Question 3 : If a role is dropped , who will own his objects ( created by it ) ?
- The Role that dropped the role
- The user that dropped the role
Question 4 : What is the default auto-suspend time when creating a new warehouse ?
- 5 min
- 10 min
- 15 min