Answer-first summary for fast verification
Answer: Set the LOAD_UNCERTAIN_FILES option to TRUE., Set the FORCE parameter to TRUE.
The question asks how to load files from a stage after their file metadata has expired, requiring two correct answers. Option A (SET LOAD_UNCERTAIN_FILES = TRUE) is correct because it allows loading files even when metadata is uncertain or expired, which directly addresses the scenario. Option C (SET FORCE = TRUE) is correct as it forces the load operation to proceed regardless of metadata issues, including expiration. The community discussion shows 100% consensus on AC, with upvoted confirmation. Option B is inefficient as it requires manual file management. Option D is disruptive as it truncates the target table unnecessarily. Option E is irrelevant to file loading from stages, as ALTER TABLE...REFRESH is for external tables, not stage files.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can files be loaded from a stage after their file metadata has expired? (Choose two.)
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
No comments yet.