Introduction

Why should you learn Snowflake? Over the last few years, Snowflake has become increasingly popular with data-led organizations and data enthusiasts. Snowflake is a data warehousing and data analysis platform built for the cloud and has been built from scratch to take full advantage of cloud features. It provides several novel features that changes how you work with data platforms.

With its increasing popularity, learning Snowflake means you increase your standing in the job market. Even if you are already knowledgeable in one or more data warehousing platforms, understanding Snowflake will give you an edge when searching for a new job or aiming for a promotion. Snowflake does not have a steep learning curve because of its simplicity and its use of SQL as the primary language. Once you have grasped the foundations of Snowflake architecture, the rest of the learning naturally flows.

Snowflake has a range of certifications available. SnowPro Core certification is at the foundation level, while other role-specific advanced certifications are also available for focused areas such as data engineering, administration, or data science on the Snowflake platform. The SnowPro Core certification is a prerequisite for the advanced certifications; therefore, it's a good way to kick-start your Snowflake journey.

This book aims to help you pass the SnowPro Core exam. This exam covers all the foundational concepts, such as Snowflake architecture, virtual warehouses, storage, security, Time Travel, cloning, data sharing, and data loading. These topics are emphasized in this book to help you prepare for the exam. Even after you pass the SnowPro Core exam, this book should remain a useful reference for you.

What Is Snowflake?

Snowflake is a relatively new cloud-optimized database, designed primarily for data warehousing solutions on the cloud. Snowflake Inc. was founded in 2012 by three data warehousing experts: Benoit Dageville, Thierry Cruanes, and Marcin Zukowski. Snowflake was designed from the ground up as a cloud-only data warehouse platform.

A significant advantage of the Snowflake platform compared to other data warehouses is its differentiated architecture. Snowflake takes full advantage of the underlying cloud platform's novel features. The outcome is a hybrid architecture in which the computation or processing layer can be scaled independently of the storage layer. Snowflake's hybrid architecture also brings out a unique array of features not seen in many other databases, introducing concepts such as zero-copy cloning, Time Travel, and secure data sharing.

Why Become SnowPro Core Certified?

There are several good reasons to get your SnowPro Core certification:

• Professional Development   Certifications are an easy pathway for continuous professional development and adding to your skillset. Because the SnowPro Core certification exam tests all the foundational concepts of Snowflake, even preparing for the exam will give you enough technical skills to develop Snowflake-based solutions.
• Increases Your Marketability   SnowPro Core certification increases your marketability to prospective employers. SnowPro Core certified candidates may negotiate a better starting salary because hiring businesses don't need to spend on training and upskilling such candidates.
• Takes You a Step Closer to Advanced Certifications   The SnowPro Core exam is a steppingstone to several advanced Snowflake certifications, such as SnowPro Advanced Data Engineer. Gaining the SnowPro Core certification will allow you to undertake any of the advanced Snowflake certifications suited to your line of work.
• Provides Proof of Professional Achievement   Organizations recognize the importance and benefits of certifications such as SnowPro Core and are increasingly encouraging their employees to obtain certification. As a result, a growing number of individuals add the SnowPro Core certifications to their professional profiles every day.
• Raises Employer Confidence   Management is more confident to take on significant initiatives and work for new clients when they have faith in the team's skills. Certifications are a great way to instill the skills in your team and gain management's confidence. If you can prove you have the necessary skills, they are more likely to undertake new initiatives and likely to put you in charge with confidence in your skills.

How to Become SnowPro Core Certified

The SnowPro Core certification is available to anyone who wishes to take the exam. There are no prerequisites; however, it is recommended that you develop an understanding and experience of the Snowflake platform with self-study and by performing hands-on exercises and experimentation with the Snowflake platform.

Snowflake's SnowPro Certification exam is administered by Pearson Vue, and you can take it in any of the 1,000+ testing centers worldwide or at home with a virtual proctor.

To register for the exam with Pearson Vue, visit https://home.pearsonvue.com/snowflake. You will need to register for a new account. Once you do, you can schedule your SnowPro Core exam.

Finally, Snowflake exam policies are subject to change. Please be sure to check www.snowflake.com/certifications for the current policies before you register and take the exam.

Like all exams, the SnowPro Core certification from Snowflake is updated periodically and may eventually be retired or replaced. At some point after Snowflake is no longer offering this exam, the old editions of our books and online tools will be retired. If you have purchased this book after the exam was retired, or are attempting to register in the Sybex online learning environment after the exam was retired, please know that we make no guarantees that this exam's online Sybex tools will be available once the exam is no longer available.

Who Should Buy This Book

This book is useful for anyone who wishes to pass the SnowPro Core certification exam. If you're new to Snowflake, this book provides the basics you'll need to learn Snowflake from scratch. The book also provides in-depth information you need to complete the exam.

How This Book Is Organized

This book consists of 10 chapters plus supplementary information, including a glossary and an assessment test, which follows this introduction. The chapters are organized as follows:

• Chapter 1, "Introduction and Overview," covers the history of Snowflake and discusses the various Snowflake certifications with a focus on the SnowPro Core certification.
• Chapter 2, "Snowflake Architecture," provides a detailed understanding of the unique Snowflake architecture, how the storage is decoupled from the compute, how data is stored in the form of micro-partitions, and the advantages of this unique architecture. The chapter also covers the critical architectural layers in Snowflake.
• Chapter 3, "Interfaces and Connectivity," talks about various interfaces, focusing on Snowflake web interfaces and SnowSQL, through which a user can interact with a Snowflake instance. The chapter also describes various connectors and drivers that can be used to connect to Snowflake. Finally, the chapter discusses the partner ecosystem in Snowflake.
• Chapter 4, "Loading Data," discusses the variety of methods provided by Snowflake for loading data, including bulk data loading and processing data in a continuous manner. This chapter walks you through the concept of staging in Snowflake, describing the internal and external stage types. The chapter also discusses loading semi-structured data, basic data transformations, and exporting data from Snowflake.
• Chapter 5, "Data Pipelines," discusses Snowflake's capability to schedule SQL statements and stored procedures through the concept of tasks. The chapter also touches on streams, which is Snowflake's method of providing change data capture.
• Chapter 6, "Continuous Data Protection," covers the components of continuous data protection and explores Time Travel, Fail-Safe, and the undrop functionality, which are Snowflake features that help protect and recover data in the event of human error. The chapter also covers the concept of transient and temporary tables.
• Chapter 7, "Cloning and Data Sharing," describes zero-copy cloning and how it works behind the scenes. The chapter then explores data sharing and the three approaches to data sharing in Snowflake.
• Chapter 8, "Performance," focuses on the performance optimization features and techniques that you can use to improve query performance and, at times, reduce costs. The chapter covers scaling up and down a virtual warehouse and autoscaling a virtual warehouse to accommodate increased concurrency. This chapter also touches on data clustering and materialized views, which can be used to optimize query execution.
• Chapter 9, "Security," explains several Snowflake features that enable security at various levels in the Snowflake software stack. The chapter discusses security implementation starting from the data storage layer to other levels such as...