This is a collection of my study notes for the Snowflake SnowPro Core certification.
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 the Snowflake's Platform, and has the knowledge necessary to design, develop, and manage secure, scalable Snowflake solutions to drive business objectives.
The SnowPro® Core Certification is designed for individuals who would like to demonstrate their knowledge of the Snowflake Data Cloud.
The candidate has a thorough knowledge of:
- Data Loading and Transformation in Snowflake.
- Virtual Warehouse Performance and Concurrency
- DDL and DML Queries
- Using Semi-Structured and Unstructured Data
- Cloning and Time Travel
- Data Sharing
- Snowflake Account Structure and Management
6 months + of practical experience with Snowflake.
Total Number of Questions: 100
Question Types: Multiple Select, Multiple Choice
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 for future use. These items are not identified on the form and do not impact your score, and additional time is factored into account for this content.
Prerequisites: No prerequisites Delivery Options:
- Online Proctoring
- Onsite Testing Centers
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 weightings.
| Domain Domain | Weightings on Exams |
|---|---|
| 1.0 Snowflake Data Cloud Features & Architecture | 25% |
| 2.0 Account Access and Security | 20% |
| 3.0 Performance Concepts | 15% |
| 4.0 Data Loading and Unloading | 10% |
| 5.0 Data Transformations | 20% |
| 6.0 Data Protection and Data Sharing | 10% |
To view exam domain, objectives and subobjectives, download the SnowPro Core Exam Study Guide.
So, how should you start once you have decided to study for this certification? In the following links, you’ll be able to find all the information regarding Snowflake to prepare you for the exam.
- Snowflake Introduction
- Snowflake Architecture
- Snowflake Pricing
- Snowflake Micro-partition
- Snowflake Clustering
- Snowflake Tables & Views
- Snowflake Stage & Storage Integration
- Snowflake Data Loading, COPY INTO & SnowPipe Commands
- Snowflake PUT & GET Commands
- Snowflake Data Warehouses
- Resource Monitors
- Snowflake Caches and Query Performance
- Time Travel, Fail-Safe & Zero-Copy Cloning
- Roles in Snowflake
- Snowflake Data Sharing
- Stored Procedures & User Defined Functions
- Tasks & Transactions
- Snowflake Streams
- Other Snowflake Objects: File Formats & Sequences
- Snowflake Ecosystem, Compliance, Data Marketplace & Security
- Summary & Tips for the Exam
- Snowflake SnowPro Core Practice Exam (Part 1)
- Snowflake SnowPro Core Practice Exam (Part 2)