SNOWPRO STUDY GUIDE OVERVIEW This is a self-learning study guide which highlights concepts that may be covered on Snowflake’s SnowPro Core Certification exams. This study guide does not guarantee certification success. For an overview and more information on the SnowPro Core Certification exam or SnowPro Advanced Certification series, please navigate here.
SNOWPRO CORE SUBJECT AREA BREAKDOWN
Snowflake Overview and Architecture: 28%
Snowflake Virtual Warehouses: 18%
Snowflake Storage and Protection: 15%
Data Movement (Loading and Unloading): 14%
Snowflake Account and Security: 12%
Snowflake Performance and Tuning: 9%
The scope and content of future exams will evolve, and these questions may not reflect updated topics, or the level of detail called upon for future exams and are provided for informational purposes only.
CORE PREREQUISITE KNOWLEDGE
The exam does not cover cloud fundamentals or basics of SQL syntax, but some questions on the exam assume knowledge of these concepts. If you need to brush up on these concepts, search through some computer science textbooks or do some light internet searching.
Database Basic Concepts
Basic Terminologies Related to Database and SQL Tables & Data Types Selecting & Manipulating Data Views, Store Procedures, Function Concepts Security (Authentication & Authorization)
Basics of Cloud Fundamentals
Types of Cloud Computing & Benefits Types of Cloud Services, Cloud Computing Architecture (Storage & Compute)