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 1 Question 16 Discussion

Which of the following Snowflake parameter can be used to Automatically Suspend Tasks which are running Data science pipelines after specified Failed Runs?
D) There is none as such available.
A) SUSPEND_TASK
B) SUSPEND_TASK_AUTO_NUM_FAILURES
C) SUSPEND_TASK_AFTER_NUM_FAILURES

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
9 months ago
I thought it was A at first, but now I'm not so sure.
upvoted 0 times
...
Aleshia
9 months ago
I agree with C, seems like the right choice.
upvoted 0 times
...
Felicitas
9 months ago
Wait, is there really no option for this?
upvoted 0 times
...
Deonna
10 months ago
Definitely B, I use it all the time.
upvoted 0 times
...
Jacklyn
10 months ago
I think it's C! That's what I remember.
upvoted 0 times
...
Benedict
10 months ago
I don't think there is a parameter for this; maybe option D is correct?
upvoted 0 times
...
Tomoko
10 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
10 months ago
I remember practicing a question about task suspension, but I can't recall the exact parameter name.
upvoted 0 times
...
Truman
11 months ago
I think the parameter might be SUSPEND_TASK_AUTO_NUM_FAILURES, but I'm not entirely sure.
upvoted 0 times
...
Elenora
11 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
11 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
11 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
11 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
11 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
11 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
1 year 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
1 year ago
I'm not sure, but A could also be a possibility.
upvoted 0 times
...
Ceola
1 year ago
I would go with C, it seems more straightforward.
upvoted 0 times
...
Phuong
1 year ago
I think B is the right choice too.
upvoted 0 times
...
...
Desirae
1 year 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
1 year ago
I agree with you, C seems like the most relevant option for automatically suspending tasks after failed runs.
upvoted 0 times
...
Kenneth
1 year 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
1 year 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
1 year 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
1 year ago
I agree with you, D) There is none as such available. We might have to handle it manually.
upvoted 0 times
...
Elke
1 year ago
I believe C) SUSPEND_TASK_AFTER_NUM_FAILURES is the parameter for that.
upvoted 0 times
...
Katina
1 year ago
I think A) SUSPEND_TASK might be the one we need to use.
upvoted 0 times
...
...
Tammi
1 year ago
Hmm, that's interesting. Can you explain why you think that?
upvoted 0 times
...
Glenna
1 year 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
1 year ago
I think it's either B or C, but C does make more sense.
upvoted 0 times
...
Willis
1 year ago
I agree, C does seem like the most logical choice.
upvoted 0 times
...
...
Michal
1 year ago
I disagree, I believe the correct answer is B) SUSPEND_TASK_AUTO_NUM_FAILURES.
upvoted 0 times
...
Tammi
1 year ago
I think the answer is C) SUSPEND_TASK_AFTER_NUM_FAILURES.
upvoted 0 times
...

Save Cancel