Answer-first summary for fast verification
Answer: From the Destination tab, set Table action to Overwrite.
To meet the requirements of replacing the schema and all the data in Table1 with the external data, you should use the 'Overwrite' option. This option, found in the Destination tab, ensures that the existing data and schema in the table are overwritten by the new values from the external data. Other options provided do not address both schema and data replacement needs.
Author: LeetQuiz Editorial Team
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?
A
From the Source tab, add additional columns.
B
From the Destination tab, set Table action to Overwrite.
C
From the Settings tab, select Enable staging.
D
From the Source tab, select Enable partition discovery.
E
From the Source tab, select Recursively.
No comments yet.