Databricks Certified Data Engineer Professional · Free Practice Question Medium
Question 5
A data engineer has a Delta Lake table named ‘orders_archive’ created using the following command:
- CREATE TABLE orders_archive
- DEEP CLONE orders
They want to sync up the new changes in the orders table to the clone.
Which of the following commands can be run to achieve this task ?
-
A
REFRESH orders_archive
-
B
SYNC orders_archive
-
C
INSERT OVERWRITE orders_archive
SELECT * FROM orders
-
D
CREATE OR REPLACE TABLE orders_archive
DEEP CLONE orders
-
E
DROP TABLE orders_archive;
CREATE TABLE orders_archive
DEEP CLONE orders
Reveal correct answer
Correct answer: D
Explanation
Cloning can occur incrementally. Executing the CREATE OR REPLACE TABLE command can sync changes from the source to the target location.
Now, If you run DESCRIBE HISTORY orders_archive, you will see a new version of CLONE operation occurred on the table.
* The last choice in the question is incorrect since dropping the table will lead to removing all the table's history.
Reference:
https://docs.databricks.com/delta/clone.html
Study materials from our exam preparation course on Udemy:
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
