SnowPro Core Certification — Question 1189

If a source table is updated while cloning is in progress, what data will be included in the cloned table?

Answer options

• A. All data from the timestamp when the user runs the query.
• B. All data from the timestamp when the user session was created.
• C. All data from the timestamp when the clone statement was initiated.
• D. All data from the timestamp when the clone statement was completed.

Correct answer: C

Explanation

The correct answer is C because the cloned table captures the data state at the moment the clone statement is initiated, ensuring that any changes made to the source table afterwards are not included. Options A, B, and D are incorrect as they refer to different timestamps that do not reflect the state of the data at the time of cloning.