Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
In the context of incremental data processing, explain the benefits of using the MERGE command over other SQL commands like INSERT OVERWRITE or CREATE OR REPLACE TABLE. Provide a detailed comparison highlighting the advantages of MERGE.
A
MERGE allows for atomic operations and schema evolution, unlike INSERT OVERWRITE.
B
MERGE supports conditional updates and inserts, ensuring data integrity without full table operations.
C
MERGE is faster than CREATE OR REPLACE TABLE for large datasets.
D
MERGE can handle complex transformations directly in the database.