100 Snowflake Cost Optimization Techniques: Practice Tests

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.]