Answer-first summary for fast verification
Answer: All data from the timestamp when the clone statement was initiated.
The correct answer is C based on Snowflake's official documentation and the community discussion analysis. According to Snowflake's documentation on cloning operations: 'During this period, DML transactions can alter the data in a source table. Subsequently, Snowflake attempts to clone the table data as it existed when the operation began.' The key phrase 'when the operation began' refers to when the clone statement was initiated, not when it completed. This ensures data consistency at the start of the cloning process. Option D (when the clone statement was completed) is incorrect because it would include ongoing DML changes during the cloning operation, which Snowflake specifically avoids. Options A and B are unrelated to the cloning operation timing and therefore incorrect.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
If a source table is being updated while a clone operation is in progress, what data will be present in the resulting clone?
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.
No comments yet.