DEA-C02 Data Movement Practice Question
A data engineer needs to periodically copy incremental data from an on-premises database into Snowflake. The source system can export CSV files to a network share, and the engineer wants to use a Snowflake-managed stage that does not require configuring an external cloud storage bucket. Which stage type should be used?
⚠ Common exam trap
The trap here is assuming that user or table stages automatically ingest from network shares, when all internal stages require files to be uploaded with PUT first.
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
✓
An internal stage created with CREATE STAGE, then upload files using PUT.
An internal stage is the correct choice because it is managed by Snowflake and does not require an external cloud storage bucket. Files from the network share can be uploaded with PUT and then loaded with COPY INTO. External stages and the various internal stage types do not provide automatic ingestion from network shares.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
A table stage referenced with @%table_name, which is shared across all users and databases.
Why it's wrong here
A table stage is an internal stage associated with a specific table and is referenced with @%table_name. It is not shared across all users and databases; it is scoped to the table. Like other internal stages, it requires files to be uploaded with PUT, and it does not automatically ingest from network shares.
- ✗
A user stage referenced with the @~ prefix, which automatically ingests files from any network share.
Why it's wrong here
A user stage is an internal stage tied to a specific user and is referenced with @~. It does not automatically ingest from network shares; files must still be uploaded with PUT. The scenario requires a general stage for a pipeline, and automatic ingestion from a network share is not a Snowflake feature. This option misstates how user stages work.
- ✗
An external stage pointing to an Amazon S3 bucket managed by the engineer.
Why it's wrong here
An external stage references a cloud storage location such as S3, Azure Blob, or GCS. The scenario explicitly states the engineer wants to avoid configuring an external cloud storage bucket. Using an external stage would require setting up and maintaining that bucket plus storage integration or credentials, which contradicts the requirement.
- ✓
An internal stage created with CREATE STAGE, then upload files using PUT.
Why this is correct
An internal stage is storage managed by Snowflake and does not require an external cloud bucket. Files can be uploaded with the PUT command from a local filesystem or network share accessible to the client, then loaded with COPY INTO. This matches the requirement for a Snowflake-managed stage without external cloud storage configuration.
About these practice questions
Courseiva writes every DEA-C02 question from scratch — 229 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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 DEA-C02 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 DEA-C02 exam.