Snowflake SnowPro Core Certification Study Guide
Published: 2022-04-23 17:01:52

**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.**

**<u>Resource Links</u>**

[Snowflake Certifications](https://www.snowflake.com/certifications/)

[SnowPro Program Policies](https://learn.snowflake.com/courses/course-v1:snowflake+CERT-PRG-POL+A/about)

[SnowPro Core Exam Guide](https://learn.snowflake.com/courses/course-v1:snowflake+CERT-SPC-GUIDE+A/about)

[Snowflake University Tracks](https://learn.snowflake.com/tracks)

[Snowflake Documentation](https://docs.snowflake.com/en/)

**<u>Exam and Certification Details</u>**

- 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

**<u>Domain Breakdown</u>**

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%

**<u>Domain Sections</u>**

**1.0 Account and Security**

- [1.1 Explain how to manage Snowflake accounts](https://dev.to/aidutcher/section-11-snowpro-core-certification-study-guide-2omi)
- [1.2 Outline security principles](https://dev.to/aidutcher/section-12-snowpro-core-certification-study-guide-1d54)
- [1.3 Define the entities and roles that are used in Snowflake](https://dev.to/aidutcher/section-13-snowpro-core-certification-study-guide-1ldp)
- [1.4 Explain the security capabilities associated with each Snowflake edition](https://dev.to/aidutcher/section-14-snowpro-core-certification-study-guide-aj4)
- 1.5 Outline data governance capabilities in Snowflake

**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