ARA-C01 Data Engineering Practice Question
A data architect needs to load data from an external stage into a Snowflake table. The data files are in Parquet format and are updated daily. The architect wants to minimize storage costs and avoid data duplication. Which command should be used to load only new or changed files?
⚠ Common exam trap
The trap here is thinking that PATTERN or FILES options can handle incremental loads, but they do not track load history; only the built-in load metadata does.
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
✓
COPY INTO with the load metadata tracking enabled to skip files already loaded.
COPY INTO leverages Snowflake's load metadata to track which files have been loaded from an external stage. It skips files that were previously loaded, ensuring only new or changed files are ingested. This automatic tracking prevents duplicates and reduces storage costs by avoiding redundant data.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
COPY INTO with the VALIDATION_MODE option to validate files before loading.
Why it's wrong here
VALIDATION_MODE is used to validate files without loading them, returning errors if any. It does not load data and does not track which files have been loaded. It is useful for testing but does not solve the problem of loading only new or changed files.
- ✗
COPY INTO with the PATTERN option to match file names based on date.
Why it's wrong here
The PATTERN option filters files by regular expression, but it does not track which files have already been loaded. If the same file name pattern is used daily, it may reload old files. It also does not prevent duplicates if files are modified. This approach requires manual tracking of loaded files.
- ✗
COPY INTO with the FILES option to specify a list of files to load.
Why it's wrong here
The FILES option allows loading a specific list of files, but it requires the architect to know which files are new or changed. It does not automatically detect changes. This manual approach is error-prone and not scalable for daily updates. It also does not prevent reloading the same file if the list is incorrect.
- ✓
COPY INTO with the load metadata tracking enabled to skip files already loaded.
Why this is correct
Snowflake's COPY INTO command automatically tracks load metadata for external stages, recording which files have been loaded. By default, it skips files that have already been loaded successfully, preventing duplicates. This is the recommended way to load only new or changed files without manual intervention, minimizing storage costs and avoiding duplication.
About these practice questions
This ARA-C01 question is part of Courseiva's 209-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 ARA-C01 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 ARA-C01 exam.