SnowPro Core Certification — Question 1227

How can files in a stage be loaded after the file metadata has expired? (Choose two.)

Answer options

• A. Set the LOAD_UNCERTAIN_FILES option to TRUE.
• B. Remove the files from the stage and reload them.
• C. Set the FORCE parameter to TRUE.
• D. Truncate the target table and reload the files.
• E. Use the ALTER TABLE...REFRESH command

Correct answer: A, C

Explanation

Setting the LOAD_UNCERTAIN_FILES option to TRUE allows the system to load files even when metadata is expired, while setting the FORCE parameter to TRUE overrides certain checks and permits the loading process. The other options do not address the expired metadata issue directly, as removing files or truncating the table do not resolve the metadata state.