Ultimate access to all questions.
You are working with a Fabric tenant that houses a lakehouse named Lakehouse1. Within Lakehouse1, there exists a Delta table consisting of eight columns. Recently, new data has been provided to you, which includes the original eight columns as well as two additional columns. You have created a Spark DataFrame containing this new data and have assigned it to a variable named df. Your task is to append the new data to the existing Delta table while adhering to the following requirements:
• Retain all pre-existing rows in the Delta table. • Ensure all new data is incorporated into the Delta table.
How should you complete the code to achieve this? Select the appropriate options.