COF-C03 Data Loading, Unloading, and Connectivity Practice Question
Which TWO statements are true regarding the behavior and management of External Tables in Snowflake?
⚠ Common exam trap
Candidates often mistakenly believe that external tables automatically detect changes in underlying cloud storage in real-time without user intervention or configured event notifications.
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 can be manually refreshed or configured to refresh automatically using cloud notifications.
External tables allow Snowflake to query data stored in external cloud storage without first importing it into Snowflake's proprietary storage format. They are read-only and rely on metadata that points to the files. To maintain performance and accuracy, they can be partitioned based on the folder structure and require metadata refreshes to detect new or removed files in the cloud bucket.
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 support the same performance optimizations as native tables, including clustering keys.
Why it's wrong here
Native Snowflake tables use proprietary micro-partitioning and can be optimized with clustering keys for performance. External tables, however, do not support clustering keys because Snowflake does not control the physical layout of the files in the external cloud storage. Consequently, queries on external tables are generally slower than on native tables.
- ✓
External tables can be manually refreshed or configured to refresh automatically using cloud notifications.
Why this is correct
To keep the metadata of an external table in sync with the actual files in the cloud storage, it must be refreshed. Snowflake allows users to trigger this manually using the ALTER EXTERNAL TABLE... REFRESH command or automatically by integrating with cloud event services like AWS SQS or Azure Event Grid.
- ✗
Data in external tables can be updated directly using standard DML commands like UPDATE or DELETE.
Why it's wrong here
External tables are strictly read-only objects in Snowflake. Since the data resides in external storage like S3 or Azure Blob, Snowflake cannot modify those files directly using SQL DML. Any changes to the data must be made by modifying the source files in the cloud storage provider's environment.
- ✗
External tables store a version of the data in Snowflake's internal storage for faster access.
Why it's wrong here
The defining characteristic of an external table is that it does NOT store the actual data within Snowflake. It only stores metadata about the files, such as their paths and formats. If you want to store the data internally for performance, you should use a standard table or a Materialized View on top of the external table.
- ✓
External tables can be partitioned to improve query performance by limiting the data scanned.
Why this is correct
Partitioning is a critical feature for external tables. By defining partitions based on the directory structure of the external stage (e.g., /year/month/day/), Snowflake can prune unnecessary files during query execution. This significantly reduces the amount of data read from the cloud storage, improving query response times and reducing costs.
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.