Snowflake COF-C02 Question Answer
What is the effect of using FORCE = TRUE in a COPY INTO < table > command?
All files will be loaded, even ones with a load status of unknown.
Files that have already been successfully loaded into the table will be loaded again.
Files that have already been successfully loaded into the table will not be loaded again.
String columns longer than the length specified in the column definition will be loaded anyway.
The Answer Is:
This question includes an explanation.
Explanation:
The correct answer is B. Files that have already been successfully loaded into the table will be loaded again .
By default, Snowflake uses load metadata to prevent the same files from being loaded into a table more than once. Setting FORCE = TRUE overrides this behavior and reloads files even if Snowflake load metadata indicates that the files were already successfully loaded.
Why B is correct:
FORCE = TRUE tells Snowflake to ignore previous load history and load files again.
Why the other options are incorrect:
A. FORCE = TRUE is not specifically about files with unknown load status.
C. This describes the default behavior when FORCE = FALSE, not when FORCE = TRUE.
D. Loading strings longer than the target column length is controlled by other loading behavior and error handling, not by FORCE.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < table > describes FORCE as an option that loads all files, regardless of whether they have been loaded previously.
