SnowPro Advanced: Data Engineer — Question 104

A Data Engineer is trying to clone a very large table from a source environment that has set
DATA_RETENTION_TIME_IN_DAYS = 0.

During the cloning operation, Data Manipulation Language (DML) transactions are executed on the source table, and the user receives the error "Data is not available."

How can this error be prevented, while ensuring successful cloning of the table? (Choose two.)

Answer options

• A. Increase the warehouse size to speed up the cloning process and avoid DML conflicts.
• B. Set the DATA_RETENTION_TIME_IN_DAYS = 1 for the table in the source environment before starting the cloning process, and revert it to = 0 after the clone is completed.
• C. Avoid all DML transactions on the source table until the cloning operation is complete.
• D. Disable Time Travel on the cloned table to reduce storage costs once the cloning is complete.
• E. Use a CREATE TABLE AS SELECT STATEMENT to create a new table, instead of creating a clone.

Correct answer: B, C

Explanation

Option B is correct because increasing the DATA_RETENTION_TIME_IN_DAYS allows the system to maintain the necessary data during the cloning process, preventing the 'Data is not available' error. Option C is also correct since halting DML transactions ensures that there are no conflicts during the cloning operation. The other options do not address the core issue related to data availability during the clone operation.