Snowflake
DEA-C02 · Question #9
Which query will show a list of the 20 most recent executions of a specified task, MYTASK, that have been scheduled within the last hour that have ended or are still running? A. B. C. D.
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #9. The question stem and answer options stay visible for context.
Snowflake Scripting and Tasks
Question
Which query will show a list of the 20 most recent executions of a specified task, MYTASK, that have been scheduled within the last hour that have ended or are still running? A. B. C. D.
Options
- Aselect * from table(information_schema.task_history(scheduled_time_range_start =>dateadd('hour',-1,current_timestamp()), result_limit => 20, task_name=>'MYTASK'))
- Bselect * from table(information_schema.task_history(scheduled_time_range_start =>dateadd('hour',-1,current_timestamp()), result_limit => 20, task_name=>'MYTASK')) where STATE IS NOT NULL
- Cselect * from table(information_schema.task_history(scheduled_time_range_start =>dateadd('hour',-1,current_timestamp()), result_limit => 20, task_name=>'MYTASK')) where STATE IN ('EXECUTING', 'SUCCEED', 'FAILED')
- Dselect * from table(information_schema.task_history(scheduled_time_range_start =>dateadd('hour',-1,current_timestamp()), result_limit => 20, task_name=>'MYTASK')) where STATE IN ('EXECUTING', 'SUCCEEDED')
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Snowflake Tasks#Information Schema#SQL Querying#Task Monitoring