COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
A Snowflake user needs to query data stored in an external cloud storage location (e.g., Amazon S3) without loading it into Snowflake tables. They want to minimize data movement and cost. Which Snowflake feature should they use?
⚠ Common exam trap
It's easy for candidates to confuse external tables with stages or Snowpipe, thinking that any external data access feature avoids loading, when only external tables allow direct querying.
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
✓
External Tables
External tables enable querying data in external cloud storage directly, without loading it into Snowflake. This reduces data movement and cost because the data stays in its original location. Internal stages, materialized views, and Snowpipe all involve loading or storing data within Snowflake, which does not meet the requirement.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
External Tables
Why this is correct
External tables allow querying data stored in external cloud storage directly, without loading it into Snowflake. They use a stage to access the files and can be queried like regular tables. This minimizes data movement and cost because data remains in the external location and is read on demand. This directly addresses the requirement.
- ✗
Snowpipe
Why it's wrong here
Snowpipe is a continuous data ingestion service that loads data from external stages into Snowflake tables. It automates loading but still moves data into Snowflake. It does not allow querying external data in place, so it would not minimize data movement as required.
- ✗
Materialized Views
Why it's wrong here
Materialized views store pre-computed results of a query on Snowflake tables. They do not query external data directly; they require data to be loaded into Snowflake first. They also consume storage and compute for maintenance. This is not suitable for querying external data without loading.
- ✗
Internal Stages
Why it's wrong here
Internal stages are used to load data into Snowflake tables. They are storage locations within Snowflake's cloud storage. While they can hold files, they do not allow querying external data in place; data must be loaded into tables first. This does not meet the requirement of minimizing data movement.
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.