Tasks for scheduling SQL in Snowflake - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a scheduled task that runs every hour.

Snowflake

CREATE OR REPLACE TASK hourly_task
  WAREHOUSE = my_warehouse
  SCHEDULE = [1]
AS
  SELECT CURRENT_TIMESTAMP();

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

A'1 MINUTE'

B'1 DAY'

C'1 HOUR'

D'10 MINUTES'

Attempts:

3 left

💡 Hint

Common Mistakes

Using '1 MINUTE' runs the task too frequently.

Using '1 DAY' runs the task too rarely.

The schedule string '1 HOUR' sets the task to run every hour.

2fill in blank

medium

Complete the code to enable the scheduled task after creation.

Snowflake

ALTER TASK hourly_task [1];

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

ARESUME

BSTART

CSUSPEND

DPAUSE

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUSPEND prevents the task from running.

PAUSE is not a valid command for tasks.

The RESUME command activates the task so it can run on schedule.

3fill in blank

hard

Fix the error in the task creation by completing the missing clause.

Snowflake

CREATE OR REPLACE TASK daily_task
  WAREHOUSE = my_warehouse
  SCHEDULE = [1]
AS
  CALL my_procedure();

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

A'1 DAY'

B'1 MINUTE'

C'1 WEEK'

D'1 MONTH'

Attempts:

3 left

💡 Hint

Common Mistakes

Using '1 MINUTE' runs the task too often.

Using '1 WEEK' or '1 MONTH' runs it less frequently than daily.

The schedule '1 DAY' runs the task once every day, which fits the daily_task name.

4fill in blank

hard

Fill both blanks to create a task that runs every 15 minutes and uses the correct warehouse.

Snowflake

CREATE OR REPLACE TASK quarter_hour_task
  WAREHOUSE = [1]
  SCHEDULE = [2]
AS
  SELECT CURRENT_DATE();

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

Amy_warehouse

B'15 MINUTES'

C15 MINUTES

Ddefault_warehouse

Attempts:

3 left

💡 Hint

Common Mistakes

Putting quotes around warehouse name.

Using wrong schedule interval.

Use the correct warehouse name and the schedule string '15 MINUTES' for a 15-minute interval.

5fill in blank

hard

Fill all three blanks to create a task that runs weekly, uses the correct warehouse, and calls the right procedure.

Snowflake

CREATE OR REPLACE TASK weekly_task
  WAREHOUSE = [1]
  SCHEDULE = [2]
AS
  CALL [3]();

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

Aanalytics_warehouse

B'1 WEEK'

Cweekly_refresh

Ddaily_refresh

Attempts:

3 left

💡 Hint

Common Mistakes

Using daily procedure name for weekly task.

Wrong warehouse name.

Incorrect schedule string.

The warehouse is 'analytics_warehouse', schedule is '1 WEEK' for weekly runs, and the procedure called is 'weekly_refresh'.