COF-C03 Data Loading, Unloading, and Connectivity Practice Question
A data analyst wants to query data stored in an external stage (Amazon S3) without loading it into a Snowflake table. The analyst creates an external table pointing to the stage. Which statement accurately describes how the data is accessed?
⚠ Common exam trap
Many exam-takers confuse external tables with regular tables, assuming data is loaded or cached persistently, when external tables always read from the external stage at query time.
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 external table reads data directly from the external stage at query time, and the data remains in the external storage location.
External tables provide a way to query data stored in external stages without loading it into Snowflake. They act as metadata pointers to files in the external stage, and queries read the data directly from those files. This allows querying data in place, which is useful for infrequent access or when data must remain in external storage.
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 external table automatically loads all data into Snowflake's storage upon creation, so queries run against local micro-partitions.
Why it's wrong here
External tables do not load data into Snowflake storage. They are metadata definitions that point to files in an external stage. Queries against external tables read directly from the external files at runtime. No data is persisted in Snowflake's storage, and no micro-partitions are created for external table data.
- ✗
The external table caches the data in the virtual warehouse's local SSD, and subsequent queries do not access the external stage again.
Why it's wrong here
While Snowflake may cache metadata and some data in the warehouse's local disk cache, external table queries always read the underlying files from the external stage. The cache is transient and not a substitute for loading. There is no persistent caching that eliminates future external stage access, and the data remains external.
- ✓
The external table reads data directly from the external stage at query time, and the data remains in the external storage location.
Why this is correct
External tables are read-only and query data in place from the external stage. Snowflake accesses the files using the stage's storage integration and parses them according to the table's file format. The data never leaves the external storage, which is ideal for infrequent queries or when data must remain in its original location.
- ✗
The external table requires a materialized view to be created on top of it before any queries can return results.
Why it's wrong here
External tables can be queried directly without any materialized view. A materialized view is not required and, in fact, cannot be created on an external table because materialized views require base tables in Snowflake. Queries against external tables work immediately after creation, provided the stage and file format are correctly configured.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
About these practice questions
Courseiva writes every COF-C03 question from scratch — 280 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 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.