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.)
- COPY INTO tablea FROM @%tablea RETURN_FAILED_ONLY = TRUE;
- COPY INTO tablea FROM @%tablea;
- COPY INTO tablea FROM @%tablea FILES = ('file5.csv');
- COPY INTO tablea FROM @%tablea FORCE = TRUE;
- COPY INTO tablea FROM @%tablea NEW_FILES_ONLY = TRUE;
- COPY INTO tablea FROM @%tablea MERGE = TRUE;
Reveal Solution Next Question