ARA-C01 · Question #94
ARA-C01 Question #94: Real Exam Question with Answer & Explanation
The correct answer is A: Use zero-copy cloning into transient tables.. Zero-copy cloning is a feature in Snowflake that allows for the creation of a clone of a database, schema, or table without duplicating any data, which is cost-effective as it saves on storage costs. Transient tables are temporary and do not incur storage costs for the time they
Question
An Architect needs to design a solution for building environments for development, test, and pre- production, all located in a single Snowflake account. The environments should be based on production data. Which solution would be MOST cost-effective and performant?
Options
- AUse zero-copy cloning into transient tables.
- BUse zero-copy cloning into permanent tables.
- CUse CREATE TABLE ... AS SELECT (CTAS) statements.
- DUse a Snowflake task to trigger a stored procedure to copy data.
Explanation
Zero-copy cloning is a feature in Snowflake that allows for the creation of a clone of a database, schema, or table without duplicating any data, which is cost-effective as it saves on storage costs. Transient tables are temporary and do not incur storage costs for the time they are not accessed, making them a cost-effective option for development, test, and pre-production environments that do not require the durability of permanent tables.
Topics
Community Discussion
No community discussion yet for this question.