Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
A data engineering team needs to read data from an external database and write it to a Databricks Delta table named 'external_data' without overwriting any existing data. Which code snippet should they use?
A
spark.sql('INSERT INTO external_data SELECT * FROM external_data_source')
B
external_data.write.format('delta').mode('ignore').saveAsTable('external_data')
C
external_data.write.format('delta').mode('append').saveAsTable('external_data')
D
external_data.write.format('delta').mode('overwrite').saveAsTable('external_data')
