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?

Real Exam

REFRESH orders_archive; SYNC orders_archive INSERT OVERWRITE orders_archive_

13.5%

CREATE OR REPLACE TABLE orders_archive DEEP CLONE orders;_

18.1%

DROP TABLE orders_archive; CREATE TABLE orders_archive DEEP CLONE orders

20.3%

INSERT OVERWRITE TABLE orders_archive SELECT * FROM orders;*_

48.1%

Databricks Certified Data Engineer - Professional