Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 2 question 123 discussion

Actual exam question from Microsoft's DP-203

Question #: 123
Topic #: 2

You have an on-premises Linux server that contains a database named DB1.

You have an Azure subscription that contains an Azure data factory named ADF1 and an Azure Data Lake Storage account named ADLS1.

You need to create a pipeline in ADF1 that will copy data from DB1 to ADLS1.

Which type of integration runtime should you use to read the data from DB1?

A. self-hosted integration runtime
B. Azure integration runtime
C. Azure-SQL Server Integration Services (SSIS)

Show Suggested Answer

Suggested Answer: A 🗳️

by JJFortunato at Jan. 9, 2024, 3:25 p.m.

Comments

Submit Cancel

e56bb91

Highly Voted 1 year, 1 month ago

ChatGPT confirmed self-hosted integration runtime

upvoted 5 times

...

bacms

Most Recent 8 months, 3 weeks ago

Selected Answer: A

A. self-hosted integration runtime

upvoted 2 times

...

7082935

1 year ago

It's kind of a toss up here, but the question does specify to "create a Data Factory pipeline to copy data". ONLY if it requested to "Create a pipeline with an Execute SSIS Package activity" would it be better to choose SSIS runtime.

upvoted 1 times

...

tadenet

1 year, 1 month ago

Selected Answer: A

the self-hosted integration runtime cannot be installed directly on a Linux server, you can set it up on a Windows machine within your network to facilitate data movement between an on-premises Linux database and Azure services.

upvoted 2 times

...

Sr18

1 year, 1 month ago

A. Self Hosted integration run times will work but SHIR need to be installed on a windows machine in same network of Linux with supported DB driver. Its not easy but still very much possible.

upvoted 1 times

Sr18

1 year, 1 month ago

After thinking, I think it will be better to use SSIS.

upvoted 1 times

...

Swayansu

1 year, 2 months ago

Selected Answer: A

Although the self-hosted IR runs on Windows, it can connect to databases hosted on Linux servers. This is possible because the self-hosted IR uses database connectors and drivers that support remote connections to databases on different operating systems.

upvoted 2 times

...

mav2000

1 year, 5 months ago

Selected Answer: C

SSIS is correct, albeit a bit overkill, because self hosted can only run on windows, this makes it the best option

upvoted 1 times

...

mav2000

1 year, 5 months ago

Selected Answer: C

This was a hard question, but indeed apparently Self-hosted integration runtime only supports windows, and Azure is for cloud platforms, so the answer is the SSIS, though it's a bit overkill because SSIS is meant for transformations

upvoted 2 times

...