SnowPro Advanced: Architect — Question 130

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?

Answer options

• A. Use zero-copy cloning into transient tables.
• B. Use zero-copy cloning into permanent tables.
• C. Use CREATE TABLE...AS SELECT (CTAS) statements.
• D. Use a Snowflake task to trigger a stored procedure to copy data.

Correct answer: A

Explanation

Using zero-copy cloning into transient tables (Option A) is the most cost-effective solution because it avoids the storage costs associated with permanent tables while providing good performance. In contrast, permanent tables (Option B) incur ongoing storage costs, CTAS statements (Option C) may require additional storage, and using a stored procedure (Option D) adds unnecessary complexity and potential latency in the process.