Answer-first summary for fast verification
Answer: The records added to the 'shallow_tickets' table will not be added to the 'tickets' table or the 'deep_tickets' table.
Once copies are created using DEEP and SHALLOW clone, data engineers can insert, update, or delete data from their copies. However, these changes are not reflected in the original table. Therefore, the correct answer is that the records added to the 'shallow_tickets' table will not be added to the 'tickets' table or the 'deep_tickets' table. More Info: Adding data to the cloned tables does not affect the original or deep-cloned tables.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When a deep clone of a Delta table named 'tickets' is created as 'deep_tickets', and then a shallow clone named 'shallow_tickets' is made from 'deep_tickets', what happens to the data in the original 'tickets' table and the 'deep_tickets' table when records are added to 'shallow_tickets'?
A
The records added to the 'shallow_tickets' table will be added to the 'tickets' table but will not be added to the 'deep_tickets' table.
B
The records added to the 'shallow_tickets' table will not be added to the 'tickets' table or the 'deep_tickets' table.
C
The records added to the 'shallow_tickets' table will be added to the 'tickets' table as well as the 'deep_tickets' table.
D
The records added to the 'shallow_tickets' table will not be added to the 'tickets' table but will be added to the 'deep_tickets' table.
E
The records cannot be added to the 'shallow_tickets' table as it is a shallow clone of a deep-cloned table.
No comments yet.