Exam4Training

Which commands should the Architect use to load only file5.csv file from the stage?

An Architect uses COPY INTO with the ON_ERROR=SKIP_FILE option to bulk load CSV files into a table called TABLEA, using its table stage. One file named file5.csv fails to load. The Architect fixes the file and re-loads it to the stage with the exact same file name it had previously.

Which commands should the Architect use to load only file5.csv file from the stage? (Choose two.)
A . COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
B . COPY INTO tablea FROM @%tablea;
C . COPY INTO tablea FROM @%tablea FILES = (‘file5.csv’);
D . COPY INTO tablea FROM @%tablea FORCE = TRUE;
E . COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
F . COPY INTO tablea FROM @%tablea MERGE = TRUE;

Answer: B, E

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Exit mobile version