SnowPro Advanced: Data Engineer — Question 97

A Data Engineer is using Time Travel to clone a table using this query:

CREATE TABLE MY_TABLE_CLONE CLONE MY_TABLE
AT (OFFSET => -60*30);

An error is returned.

What could be causing the error? (Choose two.)

Answer options

• A. The source object is an external table.
• B. The object has exceeded the maximum cloning limit.
• C. Time Travel and cloning features cannot be run together.
• D. The object cannot be cloned because it has a row access policy attached to it.
• E. The source object did not exist at the time specified in the AT | BEFORE parameter.

Correct answer: A, E

Explanation

The correct answers are A and E because an external table cannot be cloned and the source object must exist at the specified time for cloning to work. Options B, C, and D are incorrect because they do not align with the cloning and Time Travel capabilities in this context.