Free Snowflake SnowPro-Core Actual Exam Questions - Question 8 Discussion

D, because it explicitly says “all errors,” which suggests including previous partial loads too.

Maybe C could work since RETURN_ERRORS sounds like it deals with all errors detected during the load, which might include partially loaded files, unlike the others that focus on row counts.

I’d go with D here because RETURN_ALL_ERRORS sounds like it’s designed to capture everything, even from past partial loads, not just the current batch. D

C imo, RETURN_ERRORS should cover errors from partial loads too, not just row counts.

D, since it implies gathering all errors, new and from partial earlier loads.

I’m pretty sure it’s D here. RETURN_ALL_ERRORS sounds like it would cover every error found, including those from earlier partial loads, not just the current batch. C might catch errors during this copy, but from what I understand, it doesn’t track or return errors from partial loads done previously. So if the question is about including files partially loaded before, D makes more sense. A and B seem unrelated since they focus on rows, not errors.

C. RETURN_ERRORS makes sense because it’s focused on flagging errors during the copy process, which should include partial load issues, unlike A or B that are more about row counts.

Maybe C is the right pick since RETURN_ERRORS usually covers errors encountered during the load, including partial file errors. D sounds broad but might not specifically include partial loads.

I’m dropping A too since the name looks weird and probably a red herring. Between C and D, I think D makes more sense because it explicitly says “RETURN ALL ERRORS,” which fits the idea of getting errors from multiple files including ones partially loaded before. So I’d go with D on this one.

Doesn’t A look off? RETURN_-1_R0WS sounds like a trap. Maybe C or D?