COF-C02 Question 366

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose D1

  By default, COPY INTO tracks files that have been successfully loaded in the past. If you rerun the same command on the stage, Snowflake will NOT reload previously loaded files, unless you use the FORCE = TRUE option. Therefore, only the new files will be considered.

• Chose A1

  According to the Snowflake documentation, when you run the COPY INTO command again without removing the original files, all data from all of the files on the stage will be appended to the table

• 2

  I really dont understand the question