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…

Option A (RETURN_FAILED_ONLY) will only load files that previously failed to load. Since file5.csv

already exists in the stage with the same name, it will not be considered a new file and will not be

loaded.

Option D (FORCE) will overwrite any existing data in the table. This is not desired as we only want to

load the data from file5.csv.

Option E (NEW_FILES_ONLY) will only load files that have been added to the stage since the last

COPY command. This will not work because file5.csv was already in the stage before it was fixed.

Option F (MERGE) is used to merge data from a stage into an existing table, creating new rows for

any data not already present. This is not needed in this case as we simply want to load the data from

file5.csv.

Therefore, the architect can use either COPY INTO tablea FROM @%tablea or COPY INTO tablea

FROM @%tablea FILES = ('file5.csv') to load only file5.csv from the stage. Both options will load the

data from the specified file without overwriting any existing data or requiring additional

configuration