Databricks Certified Data Engineer - Professional
Get started today
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?
What happens when you query the deep and shallow clones of a delta table after the original table has been dropped?
Real Exam
Explanation:
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.