Snowflake Exam DSA-C02 Topic 3 Question 37 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 37
Topic #: 3

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?

ARUN TASK

BCALL TASK

CEXECUTE TASK

DRUN ROOT TASK

Show Suggested Answer

Suggested Answer: D

All are correct except a standard-only stream tracks row inserts only.

A standard (i.e. delta) stream tracks all DML changes to the source object, including inserts, up-dates, and deletes (including table truncates).

by Adelle at Jan 23, 2025, 02:53 AM

Limited Time Offer

25%

Off

Get Premium DSA-C02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Janella

19 hours ago

C) EXECUTE TASK seems like the most straightforward way to manually run a task. Why complicate it with 'RUN ROOT TASK'?

upvoted 0 times

...

Chantay

12 days ago

I'm not sure, but I think it could also be C) EXECUTE TASK, as it sounds like a command to trigger a task.

upvoted 0 times

...

Scarlet

12 days ago

I think the answer is D) RUN ROOT TASK. Manually triggering a task independent of the schedule sounds like it would be the root task.

upvoted 0 times

...

Sharika

16 days ago

I agree with Bettina, because it makes sense to run a scheduled task manually.

upvoted 0 times

...

Bettina

19 days ago

I think the answer is A) RUN TASK.

upvoted 0 times

...