Snowpro Advanced Architect · Free Practice Question Medium
Question 10
- A MATCH_BY_COLUMN_NAME
- B ON_ERROR = SKIP_FILE
- C FORCE = TRUE
- D LOAD_HISTORY or default LOAD_HISTORY behavior
- E VALIDATION_MODE = RETURN_ERRORS
Reveal correct answer
Correct answer: D
Explanation
✅ LOAD_HISTORY or default LOAD_HISTORY behavior
Explanation:
Snowflake automatically tracks loaded files using the COPY HISTORY metadata. When executing COPY INTO <table>, Snowflake skips files that have already been successfully loaded, ensuring that only new files are processed. This behavior is enabled by default, meaning architects do not need to specify additional parameters to achieve this functionality.
❌ Why the other options are incorrect?
VALIDATION_MODE = RETURN_ERRORS → Incorrect, because this parameter is used for validating data before loading, not for skipping previously loaded files.
ON_ERROR = SKIP_FILE → Incorrect, as this option skips files that contain errors, but does not prevent reloading of successfully processed files.
MATCH_BY_COLUMN_NAME → Incorrect, because this parameter controls column mapping during data loading, not file deduplication.
FORCE = TRUE → Incorrect, because this option forces all files to be reloaded, overriding the default behavior that prevents duplicate file loading.
For more details on COPY HISTORY and file deduplication, you can check the official Snowflake documentation.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
