Cloning considerations | Snowflake Documentation -
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.
Please, disregard mt previous reply from above. Take in consideration the below presentation:
I am reanalyzing.
Link is: https://docs.snowflake.com/en/user-guide/object-clone
Cloning and foreign key constraints
Cloning operations require time to complete, particularly for large tables. 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.
My comment: the key word in the message from SNOW FLAKE link is the word "operation". Cloning is the "operation". Hence, it seems that in the second phrase, "when the operation began" is referring to "when the cloning operation began". Hence, Snowflake tries (attempts) to clone without the DML changes occurring during cloning. But, will Snowflake do it?
Apparently YES, if we take in consdieration the proposed answer as C.
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
37ceea2
3 weeks, 2 days ago37ceea2
3 weeks, 1 day ago