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
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: 120 minutes
Languages: English & Japanese
Registration Fee: $175 USD
Passing Score: 750 + on Scaled Scoring from 100 - 1000
Click here for information on scheduling your exam.
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
2.2 Explain Virtual Warehouse best practices.
- Scale up vs scale out
- Types of virtual warehouses
Domain 3: 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.
- File size
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.
- 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
Domain 5: Snowflake Overview & Architecture
5.1 Outline key components of Snowflake’s Cloud data platform.
- Data Types
- Continuous data protection
- 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
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.
5.5 Identify Snowflake’s Partner Ecosystem
- Cloud Partners
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.
- Tables Types
- View Types
- Data Types
- External Functions
Domain 6: Storage and Protection
6.1 Outline Snowflake Storage concepts.
- Micro partitions
- Metadata Types
- Data Storage
- Stage Types
- File Formats
- Storage Monitoring
6.2 Outline Continuous Data Protection with Snowflake.
- Time Travel
- Fail Safe
- Data Encryption
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:
Paid Self Study recommended for this exam:
Free Self Study recommended for this exam:
If you're ready to schedule your exam, click here.