Answer: FORCE = TRUE

The question asks for the option that loads all files regardless of their known load status. According to Snowflake documentation and the community discussion, FORCE = TRUE is the correct choice because it forces the COPY command to load all files in the source, ignoring any previous load metadata. This ensures files are loaded whether their status is known or unknown. LOAD_UNCERTAIN_FILES = TRUE only applies to files with uncertain status (e.g., expired metadata) and does not cover all files, making it insufficient for the question's requirement. The community consensus, with multiple upvoted comments and references to official docs, strongly supports FORCE = TRUE as the optimal answer.

Author: LeetQuiz Editorial Team