ARA-C01 · Question #15
ARA-C01 Question #15: Real Exam Question with Answer & Explanation
Sign in or unlock ARA-C01 to reveal the answer and full explanation for question #15. The question stem and answer options stay visible for context.
Question
An Architect has been asked to clone schema STAGING as it looked one week ago, Tuesday June 1st at 8:00 AM, to recover some objects. The STAGING schema has 50 days of retention. The Architect runs the following statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp => '2021-06-01 08:00:00'); The Architect receives the following error: Time travel data is not available for schema STAGING. The requested time is either beyond the allowed time travel period or before the object creation time. The Architect then checks the schema history and sees the following: CREATED_ON|NAME|DROPPED_ON 2021-06-02 23:00:00 | STAGING | NULL 2021-05-01 10:00:00 | STAGING | 2021-06-02 23:00:00 How can cloning the STAGING schema be achieved?
Options
- AUndrop the STAGING schema and then rerun the CLONE statement.
- BModify the statement: CREATE SCHEMA STAGING_CLONE CLONE STAGING at (timestamp =>
- CRename the STAGING schema and perform an UNDROP to retrieve the previous STAGING
- DCloning cannot be accomplished because the STAGING schema version was not active during the
Unlock ARA-C01 to see the answer
You've previewed enough free ARA-C01 questions. Unlock ARA-C01 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.