SOL-C01 · Question #95
SOL-C01 Question #95: Real Exam Question with Answer & Explanation
The correct answer is E: Use 'ON ERROR = 'CONTINUE'` to allow the COPY statement to proceed even when errors are. 'ON_ERROR = 'CONTINUE'` ensures that the load continues despite errors. 'VALIDATION_MODE = RETURN_ERRORS' allows you to retrieve details about the errors using the RESULT SCAN' function, which can then be stored in a separate error table. This allows for later analysis of problem
Question
A data engineering team is loading data from a CSV file containing customer information into a Snowflake table. The CSV file occasionally contains malformed data, such as missing fields or fields with incorrect data types (e.g., a string in a numeric field). The team wants to ensure that the loading process continues even when such errors occur, and that the problematic records are tracked for later analysis. Which of the following COPY INTO options should be used to achieve this, and how should the error be handled?
Options
- AUse 'ON_ERROR = 'SKIP_FILE" to skip the entire file if any errors are encountered, and use
- BUse 'ON_ERROR = 'SKIP_FILE" to skip the entire file if any errors are encountered, without
- CUse 'ON ERROR = 'CONTINUE'` to allow the COPY statement to proceed even when errors are
- DUse 'ON_ERROR = 'SKIP_FILE" along with the 'SIZE_LIMIT parameter to limit the size of the file
- EUse 'ON ERROR = 'CONTINUE'` to allow the COPY statement to proceed even when errors are
Explanation
'ON_ERROR = 'CONTINUE'` ensures that the load continues despite errors. 'VALIDATION_MODE = RETURN_ERRORS' allows you to retrieve details about the errors using the RESULT SCAN' function, which can then be stored in a separate error table. This allows for later analysis of problematic records. = FALSE is necessary if the column count varies between
Topics
Community Discussion
No community discussion yet for this question.