SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ45

Performance, Cost, and Resource Optimization

An Architect must design a solution to build development, test, and pre-production environments, all within one Snowflake account. The environments must be based on production data.

Which solution would be the MOST cost-effective and performant?

Explanation

Zero-copy cloning initially shares the production data’s existing micro-partitions, so cloned environments can be created quickly without physically copying the data. Transient tables also omit the Fail-safe period and its associated storage costs, making them well suited to reproducible non-production data. CTAS and stored-procedure copying create physical copies and consume additional compute and storage.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!