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?

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?

Krishnan S Sridhar · Accepted Answer

Use zero-copy cloning into transient tables.

Krishnan S Sridhar · Answer

Use zero-copy cloning into permanent tables.

Krishnan S Sridhar · Answer

Use CREATE TABLE ... AS SELECT (CTAS) statements.

Krishnan S Sridhar · Answer

Use a Snowflake task to trigger a stored procedure to copy data.

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 155 - ARA-C01 discussion

Suggested answer: A

0 comments