Answer: LOAD_UNCERTAIN_FILES = TRUE

The LOAD_UNCERTAIN_FILES = TRUE parameter specifically addresses the scenario where file metadata has expired beyond Snowflake's 64-day retention period. By default, Snowflake skips these 'uncertain' files to prevent potential duplicate loading, but enabling this parameter forces their ingestion despite the expired metadata. This directly matches the question requirement. The other options serve different purposes: MATCH_BY_COLUMN_NAME controls column name matching behavior, ENFORCE_LENGTH enforces length constraints, and PURGE controls file deletion after loading - none of these relate to handling files with expired metadata.

Author: LeetQuiz Editorial Team