DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ93

Prepare data

You have a Fabric workspace named Workspace1 that includes a warehouse named Warehouse1 and a lakehouse named Lakehouse1. Warehouse1 has a table named Table1. Lakehouse1 has a Delta table named Table2.

You need to persist data from Table1 into Table2. The solution must use a low-code interface.

What should you do?

  • A Use a notebook to read the data from Table2 and insert the data into Table1.
  • B Use a notebook to read the data from Table1 and insert the data into Table2.
  • C Use a Dataflow Gen2 to read the data from Table1 and insert the data into Table2.
  • D Use stored procedure to read the data from Table2 and insert the data into Table1.
Explanation

Dataflow Gen2 is a low-code data-transformation and ingestion interface that can use Fabric Warehouse data as a source and write to Fabric Lakehouse Tables as a destination. Lakehouse tables use Delta Lake by default, so it supports persisting Table1 data into Table2.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!