DEV Community

Alec Dutcher
Alec Dutcher

Posted on • Edited on

Snowflake SnowPro Core Certification Study Guide

This series is intended to be a personal study guide. Information may not be comprehensive or accurate. I am sharing it in case others find it useful. Please feel free to comment if any information is inaccurate.

Resource Links

Snowflake Certifications

SnowPro Program Policies

SnowPro Core Exam Guide

Snowflake University Tracks

Snowflake Documentation

Exam and Certification Details

  • Snowflake uses a scoring scale of 0 - 1000 with a passing scaled score of 750
  • If the first attempt fails, you must wait 7 calendar days to retake the exam
  • An exam can be re-attempted 4 times in a 12 month period, each requiring payment of the exam fee
  • On-site exams must be canceled/rescheduled at least 24 hours before scheduled start time
  • Online exams may be canceled/rescheduled any time before the scheduled start time
  • An exam may be rescheduled up to 4 times
  • The fee for the SnowPro Core exam is $175 USD
  • The exam is 100 multiple choice questions and requires 80 correct answers to pass

Domain Breakdown

Account and Security 10-15%
Virtual Warehouses 15-20%
Data Movement 11-20%
Performance Management 5-10%
Snowflake Overview and Architecture 25-30%
Storage and Protection 10-15%

Domain Sections

1.0 Account and Security

2.0 Virtual Warehouses

  • 2.1 Outline compute principles
  • 2.2 Explain virtual warehouse best practices

3.0 Data Movement

  • 3.1 Outline different commands used to load data and when they should be used
  • 3.2 Define bulk as compared to continuous data loading methods
  • 3.3 Define best practices that should be considered when loading data
  • 3.4 Outline how data can be unloaded from Snowflake to either local storage or other cloud storage locations
  • 3.5 Explain how to work and load semi-structured data

4.0 Performance Management

  • 4.1 Outline best practices for Snowflake performance management on storage
  • 4.2 Outline best practices for Snowflake performance management on virtual warehouses

5.0 Snowflake Overview and Architecture

  • 5.1 Outline key components of Snowflake's cloud data platform
  • 5.2 Outline Snowflake data sharing capabilities
  • 5.3 Explain how Snowflake is different compared to legacy warehouse solutions
  • 5.4 Outline the different editions that are available, and the functionality associated with each addition
  • 5.5 Identify Snowflake's Partner Ecosystem
  • 5.6 Outline and define the purpose of Snowflake's three distinct layers
  • 5.7 Outline Snowflake's catalog and objects

6.0 Storage and Protection

  • 6.1 Outline Snowflake Storage Concepts
  • 6.2 Outline Continuous Data Protection with Snowflake

Top comments (0)