Answer-first summary for fast verification
Answer: The deep clone can be queried but querying the shallow clone will result in an error.
When a deep clone is created, all the files from the original table are copied to a new location, making it independent of the original table. A shallow clone, however, references the files from the original table, making it faster and more cost-effective to create. If the original table is dropped, the shallow clone loses access to the files it references, leading to a FileNotFoundException when queried. The deep clone, being independent, can still be queried without any issues.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What happens when you query the deep and shallow clones of a delta table after the original table has been dropped?
A
Querying both the shallow and deep clones will result in an error.
B
The deep clone can be queried but querying the shallow clone will result in an error.
C
Both the clones can be queried without facing any errors.
D
The shallow clone can be queried but querying the deep clone will result in an error.
E
The original table can only be dropped after dropping the shallow and deep clones.
No comments yet.