Which option allows skipping a problematic file during internal stage load?

• A. Use FIELD_OPTIONALLY_ENCLOSED_BY.
• B. Add the required column.
• C. Use SKIP_FILE.
• D. Set error_on_column_count_mismatch to false.

Answer: (C)

When loading data from a stage, you control how errors are handled for each file. To skip a problematic file during an internal stage load, you set the error handling to SKIP_FILE. This tells Snowflake to ignore the entire file that causes an error and continue with the remaining files in the load operation. The other options don’t provide this per-file skip behavior: field-optional enclosed-by affects how fields are parsed, not error handling; adding a required column addresses schema but doesn’t skip bad files; and changing how column-count mismatches are treated changes row-level parsing rather than skipping a problematic file.