Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake DSA-C02 Exam - Topic 3 Question 37 Discussion

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?
D) RUN ROOT TASK
A) RUN TASK
B) CALL TASK
C) EXECUTE TASK

Snowflake DSA-C02 Exam - Topic 3 Question 37 Discussion

Actual exam question for Snowflake's DSA-C02 exam
Question #: 37
Topic #: 3
[All DSA-C02 Questions]

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?

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Jerlene
9 months ago
"CALL TASK" is a thing, but not for this.
upvoted 0 times
...
Glenna
9 months ago
Wait, are we sure about that? Sounds too simple!
upvoted 0 times
...
Mary
9 months ago
Agreed, "RUN TASK" is the right one.
upvoted 0 times
...
Eladia
10 months ago
I thought it was "EXECUTE TASK" at first.
upvoted 0 times
...
Lindy
10 months ago
It's definitely "RUN TASK"!
upvoted 0 times
...
Eric
10 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
10 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
10 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
11 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
11 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
11 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
11 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
11 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
1 year 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
1 year ago
Let's go with A) RUN TASK then.
upvoted 0 times
...
Luis
1 year ago
I agree, A) RUN TASK seems like the right choice.
upvoted 0 times
...
Macy
1 year ago
I think I'll go with A) RUN TASK.
upvoted 0 times
...
...
Jose
1 year 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
1 year ago
Yeah, I'm also leaning towards RUN ROOT TASK. It just makes sense to trigger the root task directly.
upvoted 0 times
...
Bettina
1 year ago
I agree, let's go with RUN ROOT TASK. It seems like the most logical choice.
upvoted 0 times
...
Katina
1 year 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
1 year 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
1 year 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
1 year ago
True, it depends on the specific task you want to run.
upvoted 0 times
...
Rickie
1 year ago
In that case, you would choose RUN ROOT TASK.
upvoted 0 times
...
Dexter
1 year ago
But what if you want to run the root task specifically?
upvoted 0 times
...
Casie
1 year ago
I agree, EXECUTE TASK is the simplest option.
upvoted 0 times
...
...
Chantay
1 year 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
1 year 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
1 year ago
Yes, you are correct. It is D) RUN ROOT TASK.
upvoted 0 times
...
Miesha
1 year ago
I think the answer is D) RUN ROOT TASK.
upvoted 0 times
...
...
Sharika
1 year ago
I agree with Bettina, because it makes sense to run a scheduled task manually.
upvoted 0 times
...
Bettina
1 year ago
I think the answer is A) RUN TASK.
upvoted 0 times
...

Save Cancel