Snowflake Exam DSA-C02 Topic 1 Question 16 Discussion

Actual exam question for Snowflake's DSA-C02 exam

Question #: 16
Topic #: 1

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

ASUSPEND_TASK

BSUSPEND_TASK_AUTO_NUM_FAILURES

CSUSPEND_TASK_AFTER_NUM_FAILURES

DThere is none as such available.

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 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:

Submit Cancel

Micaela

1 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

Phuong

7 days ago

I think B is the right choice too.

upvoted 0 times

...

Desirae

2 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

5 days ago

I agree with you, C seems like the most relevant option for automatically suspending tasks after failed runs.

upvoted 0 times

...

Kenneth

1 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

1 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

2 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

10 days ago

I agree with you, D) There is none as such available. We might have to handle it manually.

upvoted 0 times

...

Elke

15 days ago

I believe C) SUSPEND_TASK_AFTER_NUM_FAILURES is the parameter for that.

upvoted 0 times

...

Katina

1 months ago

I think A) SUSPEND_TASK might be the one we need to use.

upvoted 0 times

...

Tammi

2 months ago

Hmm, that's interesting. Can you explain why you think that?

upvoted 0 times

...

Glenna

2 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

2 months ago

I think it's either B or C, but C does make more sense.

upvoted 0 times

...

Willis

2 months ago

I agree, C does seem like the most logical choice.

upvoted 0 times

...

Michal

2 months ago

I disagree, I believe the correct answer is B) SUSPEND_TASK_AUTO_NUM_FAILURES.

upvoted 0 times

...

Tammi

3 months ago

I think the answer is C) SUSPEND_TASK_AFTER_NUM_FAILURES.

upvoted 0 times

...