ExamGecko
Question list
Search
Search

Question 23 - DSA-C02 discussion

Report
Export

Which command manually triggers a single run of a scheduled task (either a standalone task or the root task in a DAG) independent of the schedule defined for the task?

A.
RUN TASK
Answers
A.
RUN TASK
B.
CALL TASK
Answers
B.
CALL TASK
C.
EXECUTE TASK
Answers
C.
EXECUTE TASK
D.
RUN ROOT TASK
Answers
D.
RUN ROOT TASK
Suggested answer: C

Explanation:

The EXECUTE TASK command manually triggers a single run of a scheduled task (either a standalone task or the root task in a DAG) independent of the schedule defined for the task. A successful run of a root task triggers a cascading run of child tasks in the DAG as their precedent task completes, as though the root task had run on its defined schedule.

This SQL command is useful for testing new or modified standalone tasks and DAGs before you enable them to execute SQL code in production.

Call this SQL command directly in scripts or in stored procedures. In addition, this command sup-ports integrating tasks in external data pipelines. Any third-party services that can authenticate into your Snowflake account and authorize SQL actions can execute the EXECUTE TASK command to run tasks.

asked 23/09/2024
Musoke Kamuzze
30 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first