These 5 quizzes – with 20 questions/tips each – follow closely the 100 tips recommended in my best-seller 100 Snowflake Cost Optimization Techniques video course on Udemy (look for it!). Unlike the video course, there are no hands-on code exercises here. But you will get the chance to discover one by one the 100 tips answering some simple questions, with 3 choices each.
What You Will Learn About Spending
-
How to use even bigger virtual warehouses for less expensive queries.
-
How to avoid huge cost traps in Snowflake by changing different parameter values.
-
How to optimize queries, compute, storage and overall costs in Snowflake.
-
How to properly consolidate underutilized warehouses.
-
How each serverless feature in Snowflake works and how to estimate their cost.
-
How to use parallel data transfer and processing everywhere you can.
-
How to combine different Snowflake editions in your organization.
-
How to use better data visualizations to estimate spending.
-
How to reduce your spending on all your Snowflake accounts.
What You Will Learn About Snowflake
-
Learn all about the virtual warehouses.
-
Learn how to monitor and optimize queries.
-
Learn about resource monitors and budgets.
-
Learn query acceleration and search optimization
-
Estimate efficient automatic clustering and maintenance of materialized views.
-
Learn all that matters about time travel and zero-copy cloning.
-
Learn how to efficiently deploy and combine Snowflake with other applications.
Where You May Use This Knowledge
-
Drastically reduce costs on your own Snowflake accounts.
-
Create more Snowflake accounts – with different editions – and use them efficiently.
-
Help your clients reduce spending on their Snowflake accounts.
-
Help your employer reduce costs on Snowflake in your own organization.
-
Learn to recognize the traps most people fall into when using Snowflake.
-
Create not just highly performant, but also cost-effective SQL queries.
-
Learn how to get cheaper queries with huge warehouses, using hundreds of nodes.
Who I Am
-
The only world-class expert from Canada selected for the Snowflake Data Superhero program in 2021.
-
Former SnowPro Certification SME (Subject Matter Expert) – many SnowPro exam questions have been created by me.
-
Passed most SnowPro certification exams to date, all from the first attempt.
-
Specialized in Snowflake for the past few years: I worked for Snowflake Partner companies, I served dozens of clients in this capacity or as an independent consultant, today I share my knowledge with highly specialize courses on Snowflake.
[Disclaimer: We are not affiliated with or endorsed by Snowflake, Inc.]








