SnowPro Core Certification — Question 748

While attempting to avoid data duplication, which COPY INTO [location] option should be used to load files with expired load metadata?

Answer options

• A. LOAD_UNCERTAIN_FILES
• B. FORCE
• C. VALIDATION_MODE
• D. LAST_MODIFIED

Correct answer: A

Explanation

The correct option, LOAD_UNCERTAIN_FILES, allows for the loading of files that may have expired metadata without creating duplicates. The other options do not specifically address handling expired load metadata and might lead to errors or data duplication when attempting to load such files.