Skip to main content

Last Friday was our first attempt at the SnowPro Core certification exam, and I passed! While preparing for the exam, I made a Snowflake Numbers Quiz that I want to share with you.

As for most exams, you will have to memorize some terms and definitions. Since the SnowPro Core certification exam is multiple choice, it can really help if you can answer some of the questions immediately. This will give you more time for the questions that require a little more thought, and boost your confidence for the rest of the test. There are after all 100 questions, and if you start off with 20 questions that you are not 100% certain about – this could influence your mindset for the rest of the exam.

I am a bit of a TV-quiz enthusiast, therefore I started to make my own version of the TV-quiz Per Seconde Wijzer with Snowflake information. The main idea is that you link a definition to one of the given answers. In the TV-show the host reads the definition out loud, so if you have a study partner you could do this for each other. Alternatively, they can also easily but transformed to flashcards to test yourself.

Snowflake Numbers Quiz

Lets look at an example with only numeric answers. At first we get the list of answers:

  • 1
  • 3
  • 4
  • 7
  • 10
  • 14
  • 24
  • 60
  • 64
  • 500

Similar to the TV-show, I clearly arranged the numeric answers from small to large. Now, try to match the following three definitions to one (and only one) of the numbers.

1. Minimum number of seconds that Snowflake will charge each time a Virtual Warehouse starts;

2. Days that a bulk data load is stored in the metadata of the target table;

3. Maximum number of days of fail-safe of a permanent table.

Have you matched up the definitions with a number? Don’t forget to cross them off the list. At any time you can switch up an answer with a previous given answer. Now look at the other 7 definitions, and try to link each definition to a number directly after you read it.

4. Days that a Snowpipe is stored in the metadata of the pipe;

5. Number of days that you are allowed to Time Travel if you have standard edition Snowflake;

6. Maximum MBs of uncompressed data of one micro-partition;

7. Default number of minutes until a warehouse is suspend when no queries are run;

8. Number of types of views;

9. Number of X’s of the largest possible warehouse size you can choose without contacting Snowflake support or being in the US region with AWS cloud platform;

10. Hours that the result cache is stored.

Are you all matched up? Scroll to the table at the bottom of this page to check how you did.

Do it yourself

This Snowflake Numbers Quiz can help you to study and test your knowledge. However, if you make the definitions yourself, you will gain the biggest advantage! I spend quite some time looking through the Snowflake documentation. I fact-checked the definitions and numbers. Additionally, I tried to think of definitions that are confusing or difficult to remember correctly. Although I did this two months ago, I still remembered a lot of the answers when I used it to practice for the exam last week. Of course, every person learns differently. I highly recommend finding some game or show that you enjoy and see if you can give it a Snowflake theme!

Answer table

1number of days that you are allowed to time travel if you have standard edition snowflake
3number of types of views
4number of X’s of the largest possible warehouse size you can choose without contacting Snowflake support or being in the US and AWS regions
7maximum number of days of fail-safe of a permanent table
10default number of minutes until a warehouse is suspend when no queries are run
14days that a Snowpipe is stored in the metadata of the pipe
24hours that the result cache is stored
60minimum number of seconds that Snowflake will charge each time the warehouse starts
64days that a bulk data load is stored in the metadata of the target table
500maximum MBs of uncompressed data of one micro-partition

Auteur

  • Kris Winnubst

    With a background in Business Analytics my skills are rooted in mathematics, programming and analytical problem solving. My preferred programming language is Python, but I also have experience with multiple dashboard development tools and have even won a Tableau Iron Viz contest. My favorite projects involve optimization, teamwork and analytic thinking in an ambitious and data-driven environment. My love of optimizing is not limited to my work. I enjoy solving puzzles, playing strategy games and cooking - the best kitchen is an efficient one!

Kris Winnubst

With a background in Business Analytics my skills are rooted in mathematics, programming and analytical problem solving. My preferred programming language is Python, but I also have experience with multiple dashboard development tools and have even won a Tableau Iron Viz contest. My favorite projects involve optimization, teamwork and analytic thinking in an ambitious and data-driven environment. My love of optimizing is not limited to my work. I enjoy solving puzzles, playing strategy games and cooking - the best kitchen is an efficient one!