Exam DP-200 topic 2 question 31 discussion

Actual exam question from Microsoft's DP-200

Question #: 31
Topic #: 2

You have an Azure virtual machine that has Microsoft SQL Server installed. The database on the virtual machine contains a table named Table1.
You need to copy the data from Table1 to an Azure Data Lake Storage Gen2 account by using an Azure Data Factory V2 copy activity.
Which type of integration runtime should you use?

A. Azure integration runtime
B. self-hosted integration runtime
C. Azure-SSIS integration runtime

Show Suggested Answer

Suggested Answer: B 🗳️
Copying between a cloud data source and a data source in private network: if either source or sink linked service points to a self-hosted IR, the copy activity is executed on that self-hosted Integration Runtime.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime#determining-which-ir-to-use

by alf99 at April 5, 2021, 3:20 p.m.

Comments

Submit Cancel

samkslee

Highly Voted 4 years, 2 months ago

Use the self-hosted integration runtime even if the data store is in the cloud on an Azure Infrastructure as a Service (IaaS) virtual machine. https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime#considerations-for-using-a-self-hosted-ir

upvoted 15 times

Ambujinee

4 years ago

Correct

upvoted 2 times

...

cadio30

Most Recent 4 years ago

The answer is correct either the SQL server resides in the traditional virtual server or azure virtual machine it requires "self hosted integration runtime" for the ADF to access the server.

upvoted 1 times

...

dangal95

4 years, 1 month ago

Why is B the correct answer? There is no mention that the VM running inside of a private network so shouldn't A be the correct answer?

upvoted 2 times

...

Wendy_DK

4 years, 1 month ago

correct answer is A

upvoted 1 times

Chiranjib

4 years, 1 month ago

This is incorrect. Correct Answer is B.. Please refer to samkslee's reply.

upvoted 1 times

...

alf99

4 years, 2 months ago

should be "A". All components are on cloud

upvoted 1 times

SuperAlex

4 years, 2 months ago

It's SQL Server in the Azure VM server, not Azure SQL DB. Self-hosted integration runtime can be used for SQL Servers hosted on an on-premises machine or on a Azure VM.

upvoted 6 times

...