New Year Sale 2026! 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 1 Question 16 Discussion

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

Which of the following Snowflake parameter can be used to Automatically Suspend Tasks which are running Data science pipelines after specified Failed Runs?

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 Kris at Apr 22, 2024, 07:42 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
Joanna
3 months ago
I thought it was A at first, but now I'm not so sure.
upvoted 0 times
...
Aleshia
3 months ago
I agree with C, seems like the right choice.
upvoted 0 times
...
Felicitas
3 months ago
Wait, is there really no option for this?
upvoted 0 times
...
Deonna
4 months ago
Definitely B, I use it all the time.
upvoted 0 times
...
Jacklyn
4 months ago
I think it's C! That's what I remember.
upvoted 0 times
...
Benedict
4 months ago
I don't think there is a parameter for this; maybe option D is correct?
upvoted 0 times
...
Tomoko
4 months ago
I feel like it could be SUSPEND_TASK_AFTER_NUM_FAILURES, but I might be mixing it up with something else.
upvoted 0 times
...
Weldon
4 months ago
I remember practicing a question about task suspension, but I can't recall the exact parameter name.
upvoted 0 times
...
Truman
5 months ago
I think the parameter might be SUSPEND_TASK_AUTO_NUM_FAILURES, but I'm not entirely sure.
upvoted 0 times
...
Elenora
5 months ago
I'm a bit confused by this question. I don't have much experience with Snowflake, so I'm not sure which parameter would handle that specific functionality. I'll have to guess and hope for the best on this one.
upvoted 0 times
...
Lenita
5 months ago
Okay, let me break this down. The question is asking about a Snowflake parameter that can automatically suspend tasks after failed runs. Based on the options, C seems like the most relevant one. I'll mark that for now, but I'll double-check the details before submitting.
upvoted 0 times
...
Precious
5 months ago
Hmm, I'm not too sure about this one. The question is asking about a specific Snowflake parameter, and I'm not super familiar with the Snowflake platform. I'll have to think this through carefully.
upvoted 0 times
...
Penney
5 months ago
I think the answer is C. The question specifically mentions "Automatically Suspend Tasks" after failed runs, and the SUSPEND_TASK_AFTER_NUM_FAILURES parameter sounds like it would do that.
upvoted 0 times
...
Sylvia
5 months ago
This is a tricky one. The options are all pretty similar, so I'll need to pay close attention to the details. I'm leaning towards one of the middle options, but I'm not 100% sure.
upvoted 0 times
...
Annalee
5 months ago
This is a good one! I'm pretty confident I can nail this. The key is remembering to use the correct field names and relationship syntax. I'm going with option C.
upvoted 0 times
...
Micaela
9 months ago
Woah, I didn't even know Snowflake had this feature! I'm going to go with B, it sounds the most specific to what the question is asking for.
upvoted 0 times
Jennifer
8 months ago
I'm not sure, but A could also be a possibility.
upvoted 0 times
...
Ceola
8 months ago
I would go with C, it seems more straightforward.
upvoted 0 times
...
Phuong
8 months ago
I think B is the right choice too.
upvoted 0 times
...
...
Desirae
10 months ago
Haha, I bet the developer who named these parameters was having a snowball fight while coding. C is my choice, seems the most relevant.
upvoted 0 times
Myong
8 months ago
I agree with you, C seems like the most relevant option for automatically suspending tasks after failed runs.
upvoted 0 times
...
Kenneth
9 months ago
I'm going with B, I think it's the one that automatically suspends tasks after a specified number of failures.
upvoted 0 times
...
Raylene
9 months ago
I think C is the right choice too. It makes sense for automatically suspending tasks after a certain number of failures.
upvoted 0 times
...
...
Celestina
10 months ago
I'm going with D. I haven't seen any Snowflake parameter that can do this automatically. Looks like we'll have to handle task suspensions manually.
upvoted 0 times
Katy
9 months ago
I agree with you, D) There is none as such available. We might have to handle it manually.
upvoted 0 times
...
Elke
9 months ago
I believe C) SUSPEND_TASK_AFTER_NUM_FAILURES is the parameter for that.
upvoted 0 times
...
Katina
9 months ago
I think A) SUSPEND_TASK might be the one we need to use.
upvoted 0 times
...
...
Tammi
10 months ago
Hmm, that's interesting. Can you explain why you think that?
upvoted 0 times
...
Glenna
10 months ago
Hmm, I think the answer is C. Seems like the most logical option to automatically suspend tasks after a specified number of failed runs.
upvoted 0 times
Ceola
10 months ago
I think it's either B or C, but C does make more sense.
upvoted 0 times
...
Willis
10 months ago
I agree, C does seem like the most logical choice.
upvoted 0 times
...
...
Michal
10 months ago
I disagree, I believe the correct answer is B) SUSPEND_TASK_AUTO_NUM_FAILURES.
upvoted 0 times
...
Tammi
11 months ago
I think the answer is C) SUSPEND_TASK_AFTER_NUM_FAILURES.
upvoted 0 times
...

Save Cancel