Exam SnowPro Core topic 1 question 587 discussion

Parameter FORCE - Applies to all files in the source.Reload previously loaded files. LOAD_UNCERTAIN_FILES Applies only to files flagged as uncertain.Retry loading files with uncertain status.

C is correct. Force helps to load files about we know that it was loaded before. Load_Uncertain_File s is for loading files about we do not know if they were loaded or not.

A is correct. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table To force the COPY command to load all files regardless of whether the load status is known, use the FORCE option instead.

A is correct

To force the COPY command to load all files regardless of whether the load status is known, use the FORCE option instead.

Workarounds To load files whose metadata has expired, set the LOAD_UNCERTAIN_FILES copy option to true. The copy option references load metadata, if available, to avoid data duplication, but also attempts to load files with expired load metadata. Alternatively, set the FORCE option to load all files, ignoring load metadata if it exists. Note that this option reloads files, potentially duplicating data in a table.

FORCE = TRUE when load status is known LOAD_UNCERTAIN_FILES = TRUE when load status is unknown

FORCE=TRUE