Implementing Analytics Solutions Using Microsoft Fabric — Question 14

You have a Fabric tenant that contains a lakehouse named Lakehouse’. Lakehouse1 contains a table named Tablet.
You are creating a new data pipeline.
You plan to copy external data to Table’. The schema of the external data changes regularly.
You need the copy operation to meet the following requirements:
Replace Table1 with the schema of the external data.
Replace all the data in Table1 with the rows in the external data.
You add a Copy data activity to the pipeline.
What should you do for the Copy data activity?

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because setting the Table action to Overwrite ensures that the existing data in Tablet is replaced by the new external data, which is essential given the requirement to replace all data. The other options do not fulfill the need to completely overwrite the data in Tablet or change its schema accordingly.