SnowPro Core Certification — Question 539

Which command can be added to the COPY command to make it load all files, whether or not the load status of the files is known?

Answer options

• A. FORCE = TRUE
• B. FORCE = FALSE
• C. LOAD_UNCERTAIN_FILES = TRUE
• D. LOAD_UNCERTAIN_FILES = FALSE

Correct answer: A

Explanation

The correct option is A, FORCE = TRUE, as it allows the COPY command to include all files in the load process, even if their load status is unknown. The other options do not accomplish this, with B preventing the loading of uncertain files and C and D focusing on a different aspect of file loading.