Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 9 of 38
Free Preview · 38 of 126 · questions 1–38 of 126 are free. Sign up free to sync your progress across devices.
Hotspot Scenario
Select the appropriate option to complete the statement. Click Check Answer below to see the marked solution.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
https://docs.snowflake.com/en/sql-reference/functions/task_history#examples Note To retrieve only tasks that are completed or still running, filter the query using WHERE query_id IS NOT NULL. Note that this filter is applied after RESULT_LIMIT already reduces the results returned, so the query could return 9 tasks if 1 task was scheduled but had not started yet.
This is a really a Bast*** Inside question, because all the stases are: SCHEDULED: scheduled for execution. EXECUTING: currently executing. SUCCEEDED: execution successful. FAILED: execution failed. FAILED_AND_AUTO_SUSPENDED: task failed, and was automatically suspended. CANCELLED: execution cancelled. SKIPPED
B because of reason listed by @stopthisnow (c point)