Explanation:
The correct command to synchronize the latest changes from the 'orders' table to the 'orders_archive' clone is INSERT OVERWRITE orders_archive SELECT * FROM orders. This command replaces all existing data in 'orders_archive' with the current data from 'orders', effectively syncing the clone with the original table's latest state.
REFRESH command updates table metadata, not the data itself, and SYNC is not a recognized command in Delta Lake.CREATE OR REPLACE TABLE orders_archive DEEP CLONE orders would recreate the clone, not sync existing changes.Thus, the most effective method is INSERT OVERWRITE orders_archive SELECT * FROM orders.
Ultimate access to all questions.
No comments yet.
A data engineer is working with a Delta Lake table named ‘orders_archive’, which was created using the command CREATE TABLE orders_archive DEEP CLONE orders. The engineer needs to synchronize the latest changes from the original 'orders' table to this clone. Which command should be used to accomplish this task?
A
REFRESH orders_archive; SYNC orders_archive INSERT OVERWRITE orders_archive
B
CREATE OR REPLACE TABLE orders_archive DEEP CLONE orders;
C
DROP TABLE orders_archive; CREATE TABLE orders_archive DEEP CLONE orders
D
INSERT OVERWRITE TABLE orders_archive SELECT * FROM orders;