Explanation:
The MERGE INTO command is recommended because it allows for the merging of a set of updates, insertions, and deletions from a source table into a target Delta table. This approach effectively prevents the insertion of duplicate records when writing into Delta tables. For more information, refer to the Databricks documentation on MERGE INTO and data deduplication.
Ultimate access to all questions.
A junior data engineer typically uses the INSERT INTO command to write data into a Delta table. A senior data engineer recommends a different command to prevent the insertion of duplicate records. Which command does the senior data engineer suggest?
A
APPLY CHANGES INTO
B
MERGE INTO
C
COPY INTO
D
UPDATE
E
INSERT OR OVERWRITE
No comments yet.