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

Miles

3 months ago

This is a tough one, but I think I'll go with A) RUN TASK. It's simple, to the point, and who doesn't love a good old-fashioned task run?

upvoted 0 times

Malissa

2 months ago

Let's go with A) RUN TASK then.

upvoted 0 times

...

Luis

3 months ago

I agree, A) RUN TASK seems like the right choice.

upvoted 0 times

...

Macy

3 months ago

I think I'll go with A) RUN TASK.

upvoted 0 times

...

Jose

3 months ago

D) RUN ROOT TASK has my vote. It's got 'root' in the name, so it must be the one to use, right? I mean, who doesn't love a good root task?

upvoted 0 times

Lavonna

2 months ago

Yeah, I'm also leaning towards RUN ROOT TASK. It just makes sense to trigger the root task directly.

upvoted 0 times

...

Bettina

2 months ago

I agree, let's go with RUN ROOT TASK. It seems like the most logical choice.

upvoted 0 times

...

Katina

2 months ago

I think RUN ROOT TASK is the way to go too. It sounds like it's the main task to run.

upvoted 0 times

...

Cecil

3 months ago

I'm going with B) CALL TASK. It's got a nice ring to it, you know? Like I'm summoning the task to do my bidding.

upvoted 0 times

...

Janella

4 months 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

Tresa

2 months ago

True, it depends on the specific task you want to run.

upvoted 0 times

...

Rickie

3 months ago

In that case, you would choose RUN ROOT TASK.

upvoted 0 times

...

Dexter

3 months ago

But what if you want to run the root task specifically?

upvoted 0 times

...

Casie

3 months ago

I agree, EXECUTE TASK is the simplest option.

upvoted 0 times

...

Chantay

4 months 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

4 months 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

Delisa

3 months ago

Yes, you are correct. It is D) RUN ROOT TASK.

upvoted 0 times

...

Miesha

3 months ago

I think the answer is D) RUN ROOT TASK.

upvoted 0 times

...

Sharika

4 months ago

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

upvoted 0 times

...

Bettina

4 months ago

I think the answer is A) RUN TASK.

upvoted 0 times

...