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

Tammi

10 days ago

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

upvoted 0 times

...

Glenna

11 days 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

...

Michal

12 days ago

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

upvoted 0 times

...

Tammi

21 days ago

I think the answer is C) SUSPEND_TASK_AFTER_NUM_FAILURES.

upvoted 0 times

...