
Ultimate access to all questions.
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')