Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Consider a scenario where you need to update a Delta Lake table with new data from an external source, ensuring that existing records are updated and new records are inserted without causing duplicates. Which SQL command would you use to achieve this, and why is it the best choice for this scenario?
Consider a scenario where you need to update a Delta Lake table with new data from an external source, ensuring that existing records are updated and new records are inserted without causing duplicates. Which SQL command would you use to achieve this, and why is it the best choice for this scenario?
Simulated
A
Use CREATE OR REPLACE TABLE to replace the entire table with new data.
2.7%
B
Use INSERT OVERWRITE to selectively overwrite partitions.
6.4%
C
Comments
Loading comments...