Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

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
[All DP-203 Questions]

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 Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
e56bb91
Highly Voted 4 months, 3 weeks ago
ChatGPT confirmed self-hosted integration runtime
upvoted 5 times
...
bacms
Most Recent 1 day, 19 hours ago
Selected Answer: A
A. self-hosted integration runtime
upvoted 2 times
...
7082935
3 months, 3 weeks 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
5 months 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
5 months 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
5 months ago
After thinking, I think it will be better to use SSIS.
upvoted 1 times
...
...
Swayansu
5 months, 3 weeks 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
8 months, 2 weeks 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
9 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
...
Azure_2023
10 months ago
Selected Answer: C
Azure-SQL Server Integration Services (SSIS) is currently supported for connecting to on-premises Linux servers. The other two options aren't.
upvoted 1 times
...
1d22eec
10 months, 1 week ago
Selected Answer: C
C As self-hosted integration runtime is only supported in Windows OS, Azure IR only supports withing Azure cloud platforms
upvoted 1 times
...
JJFortunato
10 months, 2 weeks ago
Correct
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...