Exam SnowPro Advanced Architect topic 1 question 4 discussion

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.

Option B and C are correct. Question says bulk load files, so there may be files other than fil5.csv. When File5.csv was modified and re-uploaded a new checksum was generated by snowflake, so B. COPY INTO tablea FROM @%tablea- will work as it won't load the files already loaded first time except file5.csv which has a new checksum now. Also, C. COPY INTO tablea FROM @%tablea FILES = ('file5.csv'); works because it specifically requests file5.csv to be loaded only(which already has anew checksum,so will be loaded successfully) Hence B and C only..

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.

there is not NEW_FILES_ONLY options.

There is no NEW_FILES_ONLY option. B and C are the correct

B and C

+1 serg_khar, should be B and C

B and C are the correct answers.

The correct answer is B&C

BC are the correct answers I think

I think purge and force are the currect answers