ARA-C01 Data Engineering Practice Question
An architect is designing a staging area for a daily ETL process where data is loaded, transformed, and then moved to a permanent production table. The staging data is only needed for 24 hours and does not require long-term Fail-safe protection. Which table type is most cost-effective?
⚠ Common exam trap
Candidates often choose Temporary tables, forgetting that Transient tables provide the same cost benefits regarding Fail-safe while allowing data to persist longer than a single session.
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
✓
Transient Tables
Transient tables are ideal for staging environments because they persist across sessions but do not incur the costs associated with Fail-safe storage. This makes them significantly cheaper for high-churn data that can be easily recreated if a system failure occurs, while still allowing for multi-day processing if needed.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Permanent Tables
Why it's wrong here
Permanent tables are the most expensive option because they include a 7-day Fail-safe period that cannot be disabled. For staging data that is only needed temporarily and can be reloaded from the source, the cost of Fail-safe storage is an unnecessary expense for the organization.
- ✗
Temporary Tables
Why it's wrong here
Temporary tables only exist for the duration of the session in which they were created. While they have no Fail-safe costs, they are not suitable for ETL processes where data needs to be accessed by different sessions or tasks over a 24-hour period, as the data is lost once the session ends.
- ✓
Transient Tables
Why this is correct
Transient tables provide a middle ground by persisting until explicitly dropped but without the Fail-safe requirement. They support Time Travel for up to one day, which is sufficient for most ETL staging needs, and they eliminate the long-term storage costs associated with the Fail-safe period.
- ✗
External Tables
Why it's wrong here
External tables query data directly from cloud storage and do not store data within Snowflake's managed storage layer. While they avoid Fail-safe costs, they are typically slower for transformation-heavy ETL processes compared to native Snowflake tables and do not provide the performance benefits of micro-partitioning.
About these practice questions
One of 209 original ARA-C01 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 ARA-C01 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 ARA-C01 exam.