SnowPro Core Certification Exam Guide

News
INTRODUCING SNOWFLAKE TRAINING FUNDS ➤  Learn more HERE. To purchase, contact us.  COVID-19 UPDATES ➤   Instructor-led classes will be delivered via virtual classroom only.

SnowPro Core Certification Exam Guide

SNOWPRO CORE CERTIFIED OVERVIEW

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 architectural principles and best practices and core aspects of Snowflake solutions including Data Loading/Unloading, Performance and Concurrency, Scaling, Security, Data types, Connectors, and Account Management. 

 

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
  • Scaling Virtual Warehouses for Performance and Concurrency 
  • Utilize Data Sharing 
  • Query Constructs and DDL & DML Operations
  • Managing and Monitoring Snowflake Accounts
  • Working with Semi-Structured Data
  • Snowflake's method for Continuous Data Protection 

 

SnowPro Badge

Number of Questions: 100

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 into account for this content.

Question Types: Multiple Select, Multiple Choice, True/False

Time Limit: 115 minutes

Languages: English & Japanese

Registration Fee: $175 USD

Passing Score: 750 + on Scaled Scoring from 0 - 1000

No Prerequisites 

Delivery Options: 

  1. Online Proctoring - Webassesor 
  2. Onsite Kryterion Testing Centers

 Click here for information on scheduling your exam. 

 


EXAM TOPICS 

 

 

Domain

Estimated Percentage Range 

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 1: 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

Domain 2: 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

Domain 3: 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

Domain 4: 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

Domain 5: Snowflake Overview & Architecture

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

  • Data Types
  • Optimizer
  • 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

Domain 6: 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, the On Demand training courses and utilizing 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

  

If you're ready to schedule your exam, click here.