When a new task is created and not activated yet, SHOW TASKS will display it in which state?

Unlock all questions

This demo includes only 20 questions. Upgrade to access hundreds of questions, flashcards, exam simulations, and disable ads.

Full question bankExam simulationsFlashcards
From $25.99Unlock all

Master Snowflake Data Engineer Exam. Study with flashcards and multiple choice questions, each question includes hints and explanations. Prepare for your success!

Multiple Choice

When a new task is created and not activated yet, SHOW TASKS will display it in which state?

Explanation:
In Snowflake, a task’s state shows whether it’s enabled and where it sits in the run cycle. If you create a new task and don’t activate it, it’s treated as paused and will appear as SUSPENDED. Activation (ALTER TASK <name> ENABLE or creating with ENABLED = TRUE) moves it into its running or scheduled state according to its schedule. ENDED means a finished task, ACTIVE means it’s currently running, and SCHEDULED refers to a task that is enabled and waiting for its next scheduled run. The key idea is that unactivated tasks are paused, so they show as SUSPENDED.

In Snowflake, a task’s state shows whether it’s enabled and where it sits in the run cycle. If you create a new task and don’t activate it, it’s treated as paused and will appear as SUSPENDED. Activation (ALTER TASK ENABLE or creating with ENABLED = TRUE) moves it into its running or scheduled state according to its schedule. ENDED means a finished task, ACTIVE means it’s currently running, and SCHEDULED refers to a task that is enabled and waiting for its next scheduled run. The key idea is that unactivated tasks are paused, so they show as SUSPENDED.

More Multiple Choice Questions
Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy