Skip to main content

SnowPro Core Certification Exam Guide

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. This exam covers Snowflake principles and best practices including: Data Loading/Unloading, Performance and Concurrency, Scaling, Security, Data types, Connectors, and Account Management.

  • Course Number

    CERT-SPC-GUIDE
  • Self-Paced

SnowPro™ Core Certification Candidate

The SnowPro ™ Core Certification is designed for individuals who would like to demonstrate their knowledge of Snowflake, the Data Platform. The candidate has a thorough knowledge of:

  • How to load and transform Data in Snowflake
  • Scale Virtual Warehouses for Performance and Concurrency
  • Utilize Data Sharing
  • Query Constructs and DDL & DML Operations
  • Manage and Monitor Snowflake Accounts
  • Work with Semi-Structured Data
  • Outline Continuous Data Protection

Exam Format

Total Number of Questions: 100
Question Types: Multiple Select, Multiple Choice, True/False
Time Limit: 115 minutes
Languages: English & Japanese
Registration Fee: $175 USD
Passing Score: 750 + Scaled Scoring from 0 - 1000
Unscored Content: Exams may include unscored items to gather statistical information. These items are not identified on the form and do not affect your score, and additional time is factored in to account for this content.
No Prerequisites
Delivery Options:

  • Online Proctoring
  • Onsite Testing Centers

Find more about registration details here.

Exam Domain Breakdown

This exam guide includes test domains, weightings, and objectives. It is not a comprehensive listing of all the content that will be presented on this examination. The table below lists the main content domains and their weighting ranges.

SnowPro Core Certification Exam Topic Percentages

1.0 Domain: Account and Security

1.1 Explain how to manage Snowflake accounts.

  • Account usage
  • Information schema

1.2 Outline security principles.

  • Multi-factor Authentication (MFA)
  • Data Encryption
  • Network Security & Policies
  • Access Control
  • Federated Authentication
  • Single Sign-On (SSO)

1.3 Define the entities and roles that are used in Snowflake.

  • Outline how privileges can be granted and revoked
  • Explain Role Hierarchy and Privilege Inheritance

1.4 Explain the Security capabilities associated with each Snowflake edition.

  • Data masking

1.5 Outline Data Governance capabilities in Snowflake

  • Data masking
  • Account usage views
  • External Tokenization

2.0 Domain: Virtual Warehouses

2.1 Outline compute principles.

  • Credit usage & billing
  • Concurrency
  • Caching

2.2 Explain Virtual Warehouse best practices.

  • Scale up vs scale out
  • Types of virtual warehouses
  • Management/monitoring

3.0 Domain: Data Movement

3.1 Outline different commands used to load data and when they should be used.

  • COPY
  • INSERT
  • PUT
  • GET
  • VALIDATE

3.2 Define bulk as compared to continuous data loading methods.

  • COPY
  • Snowpipe

3.3 Define best practices that should be considered when loading data.

  • File size
  • Folders

3.4 Outline how data can be unloaded from Snowflake to either local storage or cloud storage locations.

  • Define formats supported for unloading data from Snowflake
  • Define best practices that should be considered when unloading data

3.5 Explain how to work and load semi-structured data.

  • Supported file formats
  • VARIANT column
  • Flattening the nested structure

4.0 Domain: Performance Management

4.1 Outline best practices for Snowflake performance management on storage.

  • Clustering
  • Materialized views
  • Search Optimization

4.2 Outline best practices for Snowflake performance management on virtual warehouses.

  • Query performance and analysis
  • Query profiles
  • Query history
  • SQL optimization
  • Caching

5.0 Domain: Snowflake Overview & Architecture

5.1 Outline key components of Snowflake’s Cloud data platform.

  • Data types
  • Continuous data protection
  • Cloning
  • Types of Caching
  • Web Interface (UI)
  • Data Cloud/Data Sharing/ Data Marketplace/ Data Exchange

5.2 Outline Snowflake data sharing capabilities.

  • Account types
  • Data Marketplace & Exchange
  • Access Control options
  • Shares

5.3 Explain how Snowflake is different compared to legacy warehouse solutions.

  • Elastic Storage
  • Elastic Compute
  • Account Management

5.4 Outline the different editions that are available, and the functionality associated with each edition.

  • Pricing
  • Features

5.5 Identify Snowflake’s Partner Ecosystem

  • Cloud Partners
  • Connectors

5.6 Outline and define the purpose of Snowflake’s three distinct layers.

  • Storage Layer
  • Compute Layer
  • Cloud Services Layer

5.7 Outline Snowflake’s catalog and objects.

  • Database
  • Schema
  • Tables Types
  • View Types
  • Data Types
  • External Functions

6.0 Domain: Storage and Protection

6.1 Outline Snowflake Storage concepts.

  • Micro partitions
  • Metadata Types
  • Clustering
  • Data Storage
  • Stage Types
  • File Formats
  • Storage Monitoring

6.2 Outline Continuous Data Protection with Snowflake.

  • Time Travel
  • Fail Safe
  • Data Encryption
  • Cloning

Recommended Training

As preparation for this exam, we recommend a combination of hands-on experience, instructor-led training, on demand training courses and the utilization of self-study assets.

Instructor-Led Course recommended for this exam:
Snowflake Fundamentals

Paid Self Study recommended for this exam:
SnowPro Core Certification Preparation Course

Free Self Study recommended for this exam:
SnowPro Core Study Guide
Snowflake Hands on Essentials & Level Up Series
Snowflake in 20 Minutes

Enroll