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.)
The commands required to load only file5.csv are those that either specify to load the specific file directly or to reload all files in the stage, including those not previously loaded successfully. Using 'COPY INTO tablea FROM @%tablea FILES = ('file5.csv')' targets the specific file and loads it. Using 'COPY INTO tablea FROM @%tablea' ensures that all files in the stage, including file5.csv, will be loaded. Therefore, options B and C are correct.
Key point here - "ON_ERROR=SKIP_FILE". It means that file hasn't loaded. I we want to load the file we have to point it explicitly - this is C option or load all unloaded files (with file5.csv); its B option. If we use FORCE we will load again ALL data from the stage - it doesn't look as a good option.
there is not NEW_FILES_ONLY options.
There is no NEW_FILES_ONLY option. B and C are the correct
B and C are the correct answers.
The correct answer is B&C
BC are the correct answers I think
B and C Parameter NEW_FILES_ONLY does not exist. File is already changed in the stage, so FORCE = TRUE is not needed. Besides, it would load duplicates from the other files that reside in the stage.
C & D Here's the reasoning: C. COPY INTO tablea FROM @%tablea FILES = ('file5.csv'); This command specifically targets the file file5.csv, ensuring that only this file is loaded. D. COPY INTO tablea FROM @%tablea FORCE = TRUE; This command forces the reloading of the file, ignoring any previous load history and thus ensuring the fixed file5.csv is loaded even if the system might otherwise think it has already been processed.
The key of this question is that say: The Architect fixes the file and re-loads Here in Snowflake documentation: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table#usage-notes To reload the data, you must either specify FORCE = TRUE or ******modify the file and stage it again, which generates a new checksum.****
The answer is C and D. You cannot choose C and take any other answer other than D because the file was previously loaded (with failure). So C will never work again unless there is D.
B and C
+1 serg_khar, should be B and C
I think purge and force are the currect answers