COF-C03 Data Loading, Unloading, and Connectivity Practice Question
Exhibit
CREATE STAGE my_internal_stage FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = '|' SKIP_HEADER = 1); COPY INTO target_table FROM @my_internal_stage/data/ FILE_FORMAT = (TYPE = 'CSV' FIELD_DELIMITER = ',');
Refer to the exhibit. When the COPY INTO command is executed, which field delimiter will Snowflake use to parse the files located in the 'data/' folder of the stage?
⚠ Common exam trap
Candidates often assume that the stage-level file format is immutable or takes precedence, failing to realize that parameters defined within the COPY INTO command always override stage defaults.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The comma character (,) because the FILE_FORMAT in the COPY command overrides the stage default.
In Snowflake, if a FILE_FORMAT is specified in both the stage definition and the COPY INTO statement, the options provided in the COPY INTO statement take precedence. This allows developers to define a general default format for a stage while still having the flexibility to override specific parameters for individual load jobs without altering the permanent stage object itself.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
The pipe character (|) because it was defined first in the CREATE STAGE command.
Why it's wrong here
While the pipe character is the default for this stage, Snowflake's precedence rules favor the most specific command. The COPY INTO statement is considered more specific to the immediate task than the stage's default configuration. Therefore, the stage's default setting is ignored in favor of the delimiter explicitly provided in the load command.
- ✓
The comma character (,) because the FILE_FORMAT in the COPY command overrides the stage default.
Why this is correct
Snowflake follows a hierarchy for file format options. The options specified in the COPY INTO command have the highest priority and override any settings defined on the stage object. This design allows for maximum flexibility, enabling a single stage to hold files with slightly different formats that can be handled by different COPY statements.
- ✗
Snowflake will return an error because the delimiters in the stage and the COPY command conflict.
Why it's wrong here
This is not an error condition in Snowflake. The system is designed to allow overrides. Conflict resolution is handled by a clear set of precedence rules rather than by failing the operation. This behavior is intentional to allow users to reuse the same stage for various files that might not share the exact same formatting characteristics.
- ✗
Snowflake will attempt to auto-detect the delimiter, ignoring both specified values.
Why it's wrong here
Snowflake only performs auto-detection if the FILE_FORMAT is not explicitly defined or if specific auto-detection parameters are set. Since the user has explicitly provided a delimiter in both the stage and the COPY command, Snowflake will strictly follow the provided configuration, starting with the highest precedence, which is the COPY INTO statement itself.
About these practice questions
This COF-C03 question is part of Courseiva's 280-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Snowflake exam blueprint
This COF-C03 practice question is part of Courseiva's free Snowflake certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the COF-C03 exam.