SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ114

Implement Data Protection and Recovery

A Data Engineer is investigating a data-quality issue that caused a system failure. Because no data is available from the time of the incident, the Engineer needs to reproduce the issue without disrupting current operations.

How can a safe testing environment be established without incurring additional costs?

Explanation

Snowflake can create a zero-copy clone of a table, schema, or database at a specified historical Time Travel point. The clone is independent for testing but initially shares the original micro-partitions, so it incurs no additional data-storage cost until changes are made to the clone. CREATE … CLONE

Learn more

Community Discussion

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