SnowPro™ Core Certification Companion

1. Front Matter

   Pages i-xxii

   PDF

2. Exam Overview

   • Maja Ferle

   Pages 1-13

3. Introduction to the Snowflake Cloud Data Platform

   • Maja Ferle

   Pages 15-32

4. Snowflake Architecture

   • Maja Ferle

   Pages 33-68

5. Account Access and Security

   • Maja Ferle

   Pages 69-97

6. Storage and Performance Concepts

   • Maja Ferle

   Pages 99-133

7. Virtual Warehouses

   • Maja Ferle

   Pages 135-167

8. Data Loading and Unloading

   • Maja Ferle

   Pages 169-205

9. Data Transformation

   • Maja Ferle

   Pages 207-243

10. Data Protection

    • Maja Ferle

    Pages 245-273

11. Data Sharing

    • Maja Ferle

    Pages 275-304

12. SQL Scripting and Snowpark

    • Maja Ferle

    Pages 305-324

13. Back Matter

    Pages 325-341

    PDF

This study companion helps you prepare for the SnowPro Core Certification exam. The author  guides your studies so you will not have to tackle the exam by yourself. To help you track your progress, chapters in this book correspond to the exam domains as described on Snowflake’s website. Upon studying the material in this book, you will have solid knowledge that should give you the best shot possible at taking and passing the exam and earning the certification you deserve. 

Each chapter provides explanations, instructions, guidance, tips, and other information with the level of detail that you need to prepare for the exam. You will not waste your time with unneeded detail and advanced content which is out of scope of the exam. Focus is kept on reviewing the materials and helping you become familiar with the content of the exam that is recommended by Snowflake.



This Book Helps You

• Review the domains that Snowflake specifically recommends you study in preparation for Exam COF-C02
• Identify gaps in your knowledge that you can study and fill in to increase your chances of passing Exam COF-C02
• Level up your knowledge even if not taking the exam, so you know the same material as someone who has taken the exam
• Learn how to set up a Snowflake account and configure access according to recommended security best practices
• Be capable of loading structured and unstructured data into Snowflake as well as unloading data from Snowflake
• Understand how to apply Snowflake data protection features such as cloning, time travel, and fail safe
• Review Snowflake’s data sharing capabilities, including data marketplace and data exchange

Who This Book Is For


Those who are planning to take the SnowPro Core Certification COF-C02 exam, and anyone who wishes to gain core expertise in implementing and migrating to the Snowflake Data Cloud

• Snowflake
• SnowPro Core
• COF-C02
• Certification
• Database
• Snowflake Data Cloud
• ELT
• Data Governance
• Virtual Warehouses
• Performance Tuning

• Ljubljana, Slovenia

  Maja Ferle

Maja Ferle is a seasoned data architect with more than 30 years of experience in data analytics, data warehousing, business intelligence, data engineering, data modeling, and database administration. As a consultant, she has delivered data projects in diverse environments across the globe, always seeking to get her hands on the latest technologies and methodologies. Since embarking on the Snowflake Data Cloud, Maja has served as data architect and data engineer on several successful cloud migration projects. She holds the SnowPro Core Certification and is a Snowflake Subject Matter Expert and a Snowflake Data Superhero.