DEA-C02 · Question #81
DEA-C02 Question #81: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #81. The question stem and answer options stay visible for context.
Question
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.)
Options
- AIncrease the warehouse size to speed up the cloning process and avoid DML conflicts.
- BSet the DATA_RETENTION_TIME_IN_DAYS = 1 for the table in the source environment before
- CAvoid all DML transactions on the source table until the cloning operation is complete.
- DDisable Time Travel on the cloned table to reduce storage costs once the cloning is complete.
- EUse a CREATE TABLE AS SELECT STATEMENT to create a new table, instead of creating a
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.