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.
SnowPro Advanced: Data Engineer · Snowflake
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)