Resource monitors for cost control in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a resource monitor named 'monthly_monitor'.

Snowflake

CREATE RESOURCE MONITOR monthly_monitor WITH (CREDIT_QUOTA = [1]);

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

A10

B1000

C100

D5000

Attempts:

3 left

💡 Hint

Common Mistakes

Using too low a quota causing early suspension

Using too high a quota defeating cost control

The credit quota sets the maximum credits allowed. 1000 is a common monthly limit.

2fill in blank

medium

Complete the code to set the trigger for the resource monitor to suspend warehouses at 90% usage.

Snowflake

ALTER RESOURCE MONITOR monthly_monitor SET TRIGGERS ON [1]% DO SUSPEND;

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

A90

B50

C100

D75

Attempts:

3 left

💡 Hint

Common Mistakes

Setting trigger too low causing premature suspension

Setting trigger at 100% which may be too late

Setting the trigger at 90% means warehouses suspend when 90% of the quota is used.

3fill in blank

hard

Fix the error in the code to correctly create a resource monitor with a credit quota of 2000.

Snowflake

CREATE RESOURCE MONITOR cost_control WITH ([1] = 2000);

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

ACREDIT_CAP

BCREDIT_LIMIT

CCREDIT_QUOTA

DCREDIT_USAGE

Attempts:

3 left

💡 Hint

Common Mistakes

Using incorrect keywords like CREDIT_LIMIT or CREDIT_CAP

Omitting the quota setting

The correct keyword to set the credit limit is CREDIT_QUOTA.

4fill in blank

hard

Fill both blanks to create a resource monitor that notifies at 80% and suspends at 95%.

Snowflake

CREATE RESOURCE MONITOR alert_suspend WITH (CREDIT_QUOTA = 1500) TRIGGERS ON [1]% DO NOTIFY, [2]% DO SUSPEND;

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

A80

B90

C95

D100

Attempts:

3 left

💡 Hint

Common Mistakes

Reversing notify and suspend percentages

Setting both triggers to the same percentage

80% triggers notification, 95% triggers suspension to control costs effectively.

5fill in blank

hard

Fill all three blanks to create a resource monitor with a 3000 credit quota, notify at 70%, and suspend at 85%.

Snowflake

CREATE RESOURCE MONITOR [1] WITH (CREDIT_QUOTA = [2]) TRIGGERS ON [3]% DO NOTIFY, 85% DO SUSPEND;

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

Acost_guard

B3000

C70

D1500

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong monitor name

Setting incorrect quota or notify percentage

The monitor is named 'cost_guard', quota is 3000 credits, and notify trigger is set at 70%.