Exam DP-203 topic 2 question 121 discussion

Actual exam question from Microsoft's DP-203

Question #: 121
Topic #: 2

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?

A. Azure Synapse Analytics
B. Azure Logic Apps.
C. Azure Data Factory
D. Microsoft Power BI

Show Suggested Answer

Suggested Answer: C 🗳️

by warre at Jan. 8, 2024, 7:58 p.m.

Comments

Submit Cancel

jsav1

11 months, 3 weeks ago

Selected Answer: C

correct

upvoted 1 times

...

Happynewyear1001

11 months, 3 weeks ago

Selected Answer: C

To develop data pipeline projects that use Microsoft Power Query and meet the specified requirements, you should use Azure Data Factory (option C). Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines that can move data between supported on-premises and cloud-based data stores. With Azure Data Factory, you can use Power Query to transform and prepare your data before moving it to the destination. It supports the use of self-hosted integration runtimes for on-premises data movement.

upvoted 3 times

...

warre

11 months, 4 weeks ago

correct, chat gpt confirmed

upvoted 1 times

...