COF-C03 Data Loading, Unloading, and Connectivity Practice Question
A data engineer is designing a pipeline for a high-frequency stream of small JSON files arriving every minute in an S3 bucket. Why would Snowpipe be preferred over a scheduled COPY INTO command running on a dedicated virtual warehouse?
⚠ Common exam trap
Many candidates choose scheduled COPY INTO commands assuming warehouse auto-suspend saves money, forgetting the one-minute minimum billing increment which heavily penalizes frequent, minute-long runs.
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
✓
Virtual warehouses are billed per second with a one-minute minimum, making them expensive for frequent small loads.
Snowpipe provides a serverless compute model that automatically scales based on the volume of data being ingested, which is ideal for small, frequent files. Using a dedicated virtual warehouse for a scheduled COPY command often leads to underutilization or excessive costs because the warehouse remains active for the minimum billing period even if the load finishes in seconds.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Virtual warehouses are billed per second with a one-minute minimum, making them expensive for frequent small loads.
Why this is correct
Virtual warehouses are billed per second with a one-minute minimum, making them expensive for frequent small loads. Snowpipe uses a per-file overhead charge plus compute time, which is more cost-efficient for streaming data patterns that do not require a full warehouse to be active.
- ✗
Snowpipe requires manual intervention to trigger loads using the REST API for every single file arriving in the bucket.
Why it's wrong here
Snowpipe does not require manual intervention when auto-ingest is enabled. It uses cloud event notifications to automatically trigger the ingestion process. Suggesting it requires manual REST API calls for every file is inaccurate and would make it less efficient than a scheduled task for most automated pipelines.
- ✗
The COPY INTO command cannot process JSON files directly and requires an intermediate stage to convert data to CSV.
Why it's wrong here
The COPY INTO command is fully capable of processing semi-structured data formats like JSON, Parquet, and Avro directly from a stage. There is no requirement to convert data to CSV first, as Snowflake's ingestion engine handles these formats natively using specified file format options during the load.
- ✗
Scheduled COPY commands are limited to executing once every hour, which would create significant latency for real-time pipelines.
Why it's wrong here
Snowflake tasks can be scheduled to run as frequently as every minute, so the claim that they are limited to hourly execution is false. While Snowpipe offers lower latency through event-driven triggers, the primary reason for choosing it over a warehouse-based COPY is cost and resource management.
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
One of 280 original COF-C03 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.