SnowPro™ Core Certification Companion

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

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. 1. Exam Overview

2. Snowflake Data Platform Features

3. Snowflake Architecture

4. Account Access and Security

5. Storage and Performance Concepts

6. Virtual Warehouses

7. Data Loading and Unloading

8. Data Transformation

9. Data Protection

10. Data Sharing

11. SQL Scripting and Snowpark