Data Engineering on Microsoft Azure — Question 89

You have an on-premises database named db1 and a set-hosted integration runtime.

You have an Azure subscription that contains an Azure Data Lake Storage account named dl1.

You need to develop four data pipeline projects that will use Microsoft Power Query to copy data from db1 to dl1. The solution must meet the following requirements:

• All pipelines must use the self-hosted integration runtime.
• Each project must be stored in a separate Git repository.
• Development effort must be minimized.

What should you use?

Answer options

Correct answer: C

Explanation

The correct answer is Azure Data Factory because it is specifically designed for creating data pipelines and supports self-hosted integration runtimes, which aligns with the requirements. Azure Synapse Analytics and Microsoft Power BI are not focused on this specific integration task, and Azure Logic Apps is more suited for workflow automation rather than data pipeline development.