SnowPro Core Certification — Question 1162

Use of what parameter will allow files to be loaded even if the file metadata has expired?

Answer options

• A. MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE
• B. ENFORCE_LENGTH = TRUE
• C. PURGE = TRUE
• D. LOAD_UNCERTAIN_FILES = TRUE

Correct answer: D

Explanation

The correct answer is D, as LOAD_UNCERTAIN_FILES = TRUE specifically allows the loading of files that might have expired metadata. The other options do not relate to the loading of files with expired metadata; A deals with case sensitivity in column names, B relates to enforcing the length of data, and C concerns purging data rather than loading it.