QuestionQ38

VerifiedPrepare data

You have a Fabric lakehouse named Lakehouse1.

You have the data sources shown in the following table.

Question Image

You need to ingest data from both data sources into Lakehouse1 while minimizing maintenance and development time.

What should you use to ingest the data from each source?

An option may be used once, more than once, or not at all.

Drag & Drop
Datasource1:
Datasource2:
Explanation

A pipeline with a Copy activity supports Azure SQL Managed Instance as a source and uses built-in partitioned parallel copy, making it appropriate for large daily loads. CDC reduces the data copied to changes; Fabric’s Azure SQL Managed Instance connector supports Copy activity and CDC capabilities. An eventstream is the Fabric-native choice for real-time Azure Event Hubs data and can write the event stream to Lakehouse Delta tables.

Learn more

Community Discussion

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