SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ108

Implement Data Protection and Recovery

A Data Engineer needs to clone a very large table from a source environment configured with DATA_RETENTION_TIME_IN_DAYS = 0.

While the cloning operation is in progress, Data Manipulation Language (DML) transactions run on the source table, and the user gets the error: “Data is not available.”

How can this error be avoided while ensuring that the table is cloned successfully?

Choose two
Explanation

Cloning uses the source table state from the start of the operation. When DML occurs during a long clone and retention is set to 0, the historical data required to finish cloning can be purged. Prevent this by either avoiding DML on the source until cloning finishes or setting DATA_RETENTION_TIME_IN_DAYS = 1 on the source table before cloning and restoring it to 0 afterward.

Learn more

Community Discussion

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