Ultimate access to all questions.
You are managing a Fabric tenant that includes a lakehouse called 'Lakehouse1'. Within Lakehouse1, there is a table named 'Table1'. You are in the process of creating a new data pipeline with the goal of copying external data into Table1. The challenge is that the schema of the external data changes frequently. To address this, your copy operation must fulfill the following requirements: Replace the schema of Table1 with the schema of the external data, and replace all the data in Table1 with the rows from the external data. To achieve this, you have added a Copy data activity to the pipeline. What steps should you take for the Copy data activity to meet these requirements?