Answer-first summary for fast verification
Answer: Both the data engineers can add data to the copies of the original table received by them but the data will not be reflected back to the original table.
Once copies are created using DEEP and SHALLOW clone, the data engineers can insert, update, or delete data from their copies. However, these changes do not affect the original table. Therefore, the correct answer is the option stating that both data engineers can insert records into their copies without impacting the original table.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is using a Delta table for testing a newly launched product. Two new data engineers need to add more test cases but cannot access the original table. They each receive a copy: one via DEEP CLONE and the other via SHALLOW CLONE. What happens when they insert records into their copies?
A
The insertions made by the first data engineer will be reflected in the original table whereas the insertions made by the second data engineer will not affect the original table.
B
Both the data engineers can add data to the copies of the original table received by them but the data will not be reflected back to the original table.
C
The first data engineer can make the insertions to the table whereas the second data engineer cannot.
D
Both the data engineers get a read-only copy of the original table and thus, cannot add data to the copies of the original table received by them.
E
The insertions made by both the data engineers will be reflected in the original table.
No comments yet.