Fri. Dec 4th, 2020
Snowpro certification

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 :

  1. JSON
  2. PARQUET
  3. XML
  4. AVRO

Question 2 : Can Data Share be done between regions ?

  1. YES
  2. NO

Question 3 : If a role is dropped , who will own his objects ( created by it ) ?

  1. SYSADMIN
  2. ACCOUNTADMIN
  3. The Role that dropped the role
  4. The user that dropped the role

Question 4 : What is the default auto-suspend time when creating a new warehouse ?

  1. 5 min
  2. 10 min
  3. 15 min
  4. 1h

By Amine Hallam

Author & blogger on the latest data analytics technologies: Hadoop, Snowflake, Cloud ( AWS ), ETL .. etc

Leave a Reply

Your email address will not be published. Required fields are marked *