MENU
When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
Suggested Answer: A, B, C
Get Premium ARA-C01 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
16 comments · newest first
MA
Mabel
11 months ago
Yeah, FAIL is not a valid option for ON_ERROR.
KR
Krissy
11 months ago
Wait, are you sure about SKIP_FILE? Sounds off.
JE
Jestine
11 months ago
I thought FAIL was an option too, right?
CH
Cherry
11 months ago
Definitely agree, those are the main options!
ME
Meaghan
12 months ago
You can use CONTINUE, SKIP_FILE, and ABORT_STATEMENT.
CO
Coral
12 months ago
I’m pretty confident that CONTINUE and ABORT_STATEMENT are options, but I can't recall if SKIP_FILE is also included.
IZ
Izetta
12 months ago
I feel like FAIL isn't a valid option for ON_ERROR. It seems more like a status than an action.
LA
Laquita
1 year ago
I remember practicing a question where SKIP_FILE was one of the options. It might be correct here too.
CA
Cassi
1 year ago
I think the ON_ERROR clause has options like CONTINUE and ABORT_STATEMENT, but I'm not sure about the others.
BR
Brynn
1 year ago
This is a good question to practice for the exam. I'll make sure to review the COPY INTO documentation so I'm familiar with all the ON_ERROR options before the test.
RO
Rodolfo
1 year ago
Okay, let's see here... I know CONTINUE and ABORT_STATEMENT are options, but I can't remember the others off the top of my head. I'll make sure to read the question carefully and eliminate the options I'm not sure about.
ER
Ernest
1 year ago
Hmm, I'm not too sure about the different options for the ON_ERROR clause. I'll need to review my notes on COPY INTO to make sure I understand the differences between them.
GA
Gail
1 year ago
This looks like a straightforward question about the COPY INTO command in Snowflake. I'm pretty confident I can answer this one.
CA
Catalina
1 year ago
I think the "server" option is the one that specifies an external NTP source, but I'll double-check the ntp.conf file to be sure.
MA
Malcom
1 year ago
Okay, I think I've got this. Work Orders and Cases would be the best way to implement the standard process and ensure asset traceability.
LO
Louisa
1 year ago
Based on my understanding, events are primarily used for debugging and logging purposes, not for return values. So I think option C is the correct answer here.