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