Snowflake DSA-C02 Exam - 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

Jerlene

3 months ago

"CALL TASK" is a thing, but not for this.

upvoted 0 times

...

Glenna

3 months ago

Wait, are we sure about that? Sounds too simple!

upvoted 0 times

...

Mary

3 months ago

Agreed, "RUN TASK" is the right one.

upvoted 0 times

...

Eladia

4 months ago

I thought it was "EXECUTE TASK" at first.

upvoted 0 times

...

Lindy

4 months ago

It's definitely "RUN TASK"!

upvoted 0 times

...

Eric

4 months ago

I'm leaning towards "CALL TASK," but I remember there being some confusion about that in our last study group.

upvoted 0 times

...

Jesus

4 months ago

I feel like "RUN ROOT TASK" could be the answer since it specifies the root task, but I can't recall if that's the standard terminology.

upvoted 0 times

...

Lashawn

4 months ago

I remember practicing a similar question, and I think "EXECUTE TASK" was mentioned as a possible command, but it doesn't sound quite right for this context.

upvoted 0 times

...

Devora

5 months ago

I think the command might be "RUN TASK," but I'm not entirely sure if that's the exact phrasing used in the documentation.

upvoted 0 times

...

Earlean

5 months ago

Ah, this is a good one. I remember learning about this in class. The answer is B. CALL TASK. That's the command to manually trigger a scheduled task outside of its normal schedule.

upvoted 0 times

...

Jade

5 months ago

I think the answer is C. EXECUTE TASK. That sounds like the right command to manually run a scheduled task, but I'm not 100% sure.

upvoted 0 times

...

Michell

5 months ago

Hmm, I'm a bit unsure about this one. I know there's a way to manually run a task, but I can't remember the exact command. I'll have to think this through carefully.

upvoted 0 times

...

Elliott

5 months ago

I'm pretty sure the answer is A. RUN TASK. That's the command I've used before to manually trigger a scheduled task.

upvoted 0 times

...

Miles

10 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

9 months ago

Let's go with A) RUN TASK then.

upvoted 0 times

...

Luis

9 months ago

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

upvoted 0 times

...

Macy

9 months ago

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

upvoted 0 times

...

Jose

10 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

8 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

8 months ago

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

upvoted 0 times

...

Katina

9 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

10 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

10 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

9 months ago

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

upvoted 0 times

...

Rickie

9 months ago

In that case, you would choose RUN ROOT TASK.

upvoted 0 times

...

Dexter

10 months ago

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

upvoted 0 times

...

Casie

10 months ago

I agree, EXECUTE TASK is the simplest option.

upvoted 0 times

...

Chantay

10 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

10 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

10 months ago

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

upvoted 0 times

...

Miesha

10 months ago

I think the answer is D) RUN ROOT TASK.

upvoted 0 times

...

Sharika

11 months ago

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

upvoted 0 times

...

Bettina

11 months ago

I think the answer is A) RUN TASK.

upvoted 0 times

...