Answer-first summary for fast verification
Answer: INSERT OVERWRITE
The `INSERT OVERWRITE` command is the optimal choice for the data engineer's objective. It enables the insertion of new data into an existing table while simultaneously overwriting any existing data. This ensures the table exclusively reflects the latest data, making it perfect for scenarios requiring a complete dataset refresh. For example: ```sql INSERT OVERWRITE TABLE existing_delta_table SELECT * FROM new_data_table; ``` This example illustrates how `INSERT OVERWRITE` can efficiently replace all data in `existing_delta_table` with data from `new_data_table`, keeping the dataset up-to-date in a single operation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A data engineer is tasked with refreshing an existing Delta table by replacing all its records with new data from a recent batch process. The goal is to ensure the table only contains the most current data, using a single operation for efficiency. Which SQL command should the engineer use for this purpose?
A
MERGE INTO
B
INSERT INTO
C
ALTER TABLE
D
UPDATE
E
INSERT OVERWRITE
No comments yet.