COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture
A user needs to query data stored in an external stage that points to an Amazon S3 bucket. The user has been granted the necessary privileges on the stage and the storage integration. Which of the following is required to successfully query the data directly from the stage using a SELECT statement?
⚠ Common exam trap
The trap here is assuming that data must always be loaded into a table before querying, overlooking Snowflake's ability to query external stages directly.
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 stage must be defined with a file format that matches the data.
To query data directly from an external stage, the stage must have a file format defined that matches the data files. This enables Snowflake to interpret the data correctly. Loading data into a table is optional, and administrative roles or same-region buckets are not required. The key is proper configuration of the stage and appropriate privileges.
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 S3 bucket must be in the same AWS region as the Snowflake account.
Why it's wrong here
Snowflake can access S3 buckets in any region, though cross-region access may incur additional latency and data transfer costs. There is no requirement for the bucket to be in the same region as the Snowflake account. However, for optimal performance, same-region is recommended.
- ✓
The external stage must be defined with a file format that matches the data.
Why this is correct
To query data directly from an external stage, the stage must be configured with a file format that matches the data files (e.g., CSV, JSON, Parquet). This allows Snowflake to parse the files correctly. Without a proper file format, the query will fail or return incorrect results. The file format can be specified in the stage definition or in the SELECT statement.
- ✗
The user must have the ACCOUNTADMIN role to query external stages.
Why it's wrong here
Querying external stages does not require the ACCOUNTADMIN role. Users need privileges on the stage and the storage integration, but these can be granted to non-admin roles. ACCOUNTADMIN is not necessary and would violate the principle of least privilege.
- ✗
The data must first be loaded into a Snowflake table using COPY INTO.
Why it's wrong here
While loading data into a table is common, Snowflake allows querying data directly from an external stage without loading. This is useful for ad-hoc queries or data exploration. The COPY INTO command is not required for direct querying; it is used for persistent loading.
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
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.