Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 4 of 60
Free Preview · 60 of 198 · questions 1–60 of 198 are free. Sign up free to sync your progress across devices.
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
A - Is invalid B - Will skill all uploaded file C - Will force to reload all file. D- Will make sure only File5.csv gets reloaded. E - Invalid F - Invalid.
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.