Explanation:
Correct answer: B — CREATE OR REPLACE TABLE orders_archive DEEP CLONE orders;
A DEEP CLONE creates an independent copy of the source Delta table at a point in time. It does not stay linked to the original table, so there’s no “sync/refresh” command that will pull in later changes automatically. To bring the clone up to date, you re-run the clone, replacing the existing cloned table.
Why others are wrong:
REFRESH only refreshes metadata/caching; it does not resync a deep clone (and SYNC isn’t a valid Delta SQL command here).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;