
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.