Hello and Welcome to Snowflake SnowPro Core Certification

If, like me you come from the database background you’ll find using a product like Snowflake a real breath of fresh air. Easy to use, fast, agile, and packed with great features, it removes a lot of the tedious administrational tasks you tend to associate with pretty much every other database. It’s no wonder why it’s had the level of success it has and its great fun to use. I hope you find this content helpful.

This course contains 3 SnowPro Core Practice exams which will prepare you for taking the actual exam. Some of the questions are multi-select and some are multiple-choice. Each exam contains 100 questions with a required score of 80% to pass. If a question is multi-select, it will either say how many answers to choose or just to choose all that apply. This reflects the format of the actual exam. The exam will ask you some pretty specific things, like "how long is the query cache kept for?" or "what is the max size of the variant data type?". I have included questions like these to make sure that you study these specific details. It is critical that you read the official Snowflake documentation as part of your studies, where you will find valuable explanations and diagrams.

The sheer simplicity of the Snowflake means it is straightforward to getting up and running. This also means a lot of users don’t move past the basics, because they never need to. For everyday workloads Snowflake runs out of the box and if queries start to take a little longer, well, you can always scale up at the touch of a button!

The questions contained in these practice tests cover the follow subject areas:

1. Snowflake Overview and Architecture

2. Snowflake Virtual Warehouses

3. Snowflake Storage and Protection

4. Data Movement (Loading & Unloading)

5. Snowflake Account, Security and Sharing

6. Snowflake Performance and Tuning

7. Working with Semi-Structured Data

8. Streams & Tasks

The exam does not cover cloud fundamentals or basics of SQL syntax, but some questions on the exam assume knowledge of these concepts. It's worthwhile brushing up on some of these areas if your not familiar with them.

This guide does not guarantee success but forms part of your preparation to succeed.