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

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

Cost Optimization

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.

How the community answered

(23 responses)

A
78% (18)
B
4% (1)
C
13% (3)
D
4% (1)

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

#Zero-copy cloning#Transient tables#Environment management#Cost optimization

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice