Why pipelines automate data freshness in Snowflake - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

Snowflake

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

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

A'1 MINUTE'

B'1 HOUR'

C'10 MINUTES'

D'1 DAY'

Attempts:

3 left

💡 Hint

Common Mistakes

Using '1 MINUTE' runs too frequently.

Using '1 DAY' runs too infrequently.

The schedule '1 HOUR' sets the task to run every hour, ensuring data freshness hourly.

2fill in blank

medium

Complete the code to resume the Snowflake task after creation.

Snowflake

ALTER TASK hourly_task [1];

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

ARESUME

BSUSPEND

CPAUSE

DSTART

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUSPEND stops the task.

START is not a valid Snowflake task command.

RESUME activates the task so it can run on its schedule.

3fill in blank

hard

Fix the error in the task creation by choosing the correct schedule syntax.

Snowflake

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

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

A'EVERY 24 HOURS'

B'24 HOURS'

C'DAILY'

D'1 DAY'

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'DAILY' is invalid syntax.

Using 'EVERY 24 HOURS' is not supported.

Snowflake expects schedule intervals like '1 DAY' for daily tasks.

4fill in blank

hard

Fill both blanks to create a task that runs every 30 minutes and calls the correct procedure.

Snowflake

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

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

Ahalf_hour_task

Bhourly_task

C'30 MINUTES'

D'60 MINUTES'

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'hourly_task' with '30 MINUTES' is inconsistent.

Using '60 MINUTES' runs hourly, not half-hourly.

The task name 'half_hour_task' and schedule '30 MINUTES' set the task to run every half hour.

5fill in blank

hard

Fill all three blanks to create a task that runs daily, calls the correct procedure, and resumes the task.

Snowflake

CREATE OR REPLACE TASK [1]
  WAREHOUSE = my_warehouse
  SCHEDULE = '[2]'
AS
  CALL [3];

ALTER TASK [1] RESUME;

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

Adaily_task

B1 DAY

Crefresh_daily_data()

Drefresh_hourly_data()

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'refresh_hourly_data()' for a daily task.

Forgetting to resume the task after creation.

The task named 'daily_task' runs every '1 DAY' and calls 'refresh_daily_data()'. The ALTER TASK command resumes it.