Snowflake editions and pricing - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to select the Snowflake edition that includes all features.

Snowflake

SELECT edition FROM snowflake_account WHERE edition = '[1]';

Drag options to blanks, or click blank then click option'

ABusiness Critical

BVirtual Private Snowflake

CEnterprise

DStandard

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Standard or Enterprise which have fewer features.

Confusing Business Critical with the highest edition.

The Virtual Private Snowflake edition includes all features and highest security.

2fill in blank

medium

Complete the code to find the pricing model based on compute usage.

Snowflake

SELECT pricing_model FROM snowflake_pricing WHERE model = '[1]';

Drag options to blanks, or click blank then click option'

ASubscription

BFlat Rate

CReserved

DOn-Demand

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting Subscription which is a fixed monthly fee.

Confusing Reserved with On-Demand pricing.

The On-Demand pricing model charges based on actual compute usage.

3fill in blank

hard

Fix the error in the query to list editions that support HIPAA compliance.

Snowflake

SELECT edition FROM snowflake_account WHERE [1] = TRUE;

Drag options to blanks, or click blank then click option'

Ahipaa_compliant

Bhipaa

Ccompliance_hipaa

Dis_hipaa

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect or incomplete column names.

Forgetting to check the exact column name in the schema.

The correct column name for HIPAA compliance is hipaa_compliant.

4fill in blank

hard

Fill both blanks to calculate total cost based on credits used and price per credit.

Snowflake

SELECT [1] * [2] AS total_cost FROM usage_data;

Drag options to blanks, or click blank then click option'

Acredits_used

Bprice_per_credit

Ctotal_credits

Dcost_per_credit

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing up the variable names for credits and price.

Using total_credits instead of credits_used.

Multiplying credits_used by price_per_credit gives the total cost.

5fill in blank

hard

Fill all three blanks to filter editions by region and calculate monthly cost.

Snowflake

SELECT edition, region, [1] * [2] AS monthly_cost FROM pricing WHERE region = '[3]';

Drag options to blanks, or click blank then click option'

Amonthly_credits

Bcredit_price

Cus_west

Dmonthly_usage

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect variable names for credits or price.

Choosing wrong region string.

Multiply monthly_credits by credit_price to get monthly cost for the us_west region.