ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam
Go to Exam

Exam DP-200 topic 2 question 5 discussion

Actual exam question from Microsoft's DP-200
Question #: 5
Topic #: 2
[All DP-200 Questions]

DRAG DROP -
Your company manages on-premises Microsoft SQL Server pipelines by using a custom solution.
The data engineering team must implement a process to pull data from SQL Server and migrate it to Azure Blob storage. The process must orchestrate and manage the data lifecycle.
You need to configure Azure Data Factory to connect to the on-premises SQL Server database.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Show Suggested Answer Hide Answer
Suggested Answer:
Step 1: Create a virtual private network (VPN) connection from on-premises to Microsoft Azure.
You can also use IPSec VPN or Azure ExpressRoute to further secure the communication channel between your on-premises network and Azure.
Azure Virtual Network is a logical representation of your network in the cloud. You can connect an on-premises network to your virtual network by setting up IPSec
VPN (site-to-site) or ExpressRoute (private peering).
Step 2: Create an Azure Data Factory resource.
Step 3: Configure a self-hosted integration runtime.
You create a self-hosted integration runtime and associate it with an on-premises machine with the SQL Server database. The self-hosted integration runtime is the component that copies data from the SQL Server database on your machine to Azure Blob storage.
Note: A self-hosted integration runtime can run copy activities between a cloud data store and a data store in a private network, and it can dispatch transform activities against compute resources in an on-premises network or an Azure virtual network. The installation of a self-hosted integration runtime needs on an on- premises machine or a virtual machine (VM) inside a private network.
References:
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-powershell
by epgd at Nov. 28, 2019, 8:39 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
cnuusd
Highly Voted 5 years, 3 months ago
Create an Azure Data Factory Configure a self-hosted integration runtime Configure on-premises SQL Server Instance ................
upvoted 71 times
avestabrzn
5 years, 2 months ago
totally agree
upvoted 5 times
...
zenomas
5 years, 1 month ago
curious, what sort of configuration do we need in on-prem SQL Server instance? creating user account and so on?
upvoted 2 times
Yuri1101
5 years ago
Just the installation of the IR in the on-premise server. I guess it can be called configuration as well.
upvoted 1 times
BRW
4 years, 3 months ago
You may need to create a db user to use in a link service in ADF.
upvoted 1 times
...
...
...
...
epgd
Highly Voted 5 years, 5 months ago
It's not necessary to Create a virtual private network (VPN) connection from on-premises to Microsoft Azure.
upvoted 23 times
John123123
5 years, 1 month ago
"The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network." - https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime Implies that a virtual private network is indeed required.
upvoted 8 times
zenomas
5 years, 1 month ago
I think it is not required when the machine is internet-facing with connectivity to on-prem SQL Server.
upvoted 1 times
visakh
4 years, 11 months ago
Its not madatory. But its a security best practice to use VPN See https://docs.microsoft.com/en-us/azure/data-factory/data-movement-security-considerations
upvoted 1 times
...
...
cowtown
4 years, 10 months ago
The company may have ExpressRoute setup.
upvoted 3 times
...
...
...
cadio30
Most Recent 3 years, 12 months ago
Create an Azure Data Factory Configure a self-hosted integration runtime Configure on-premises SQL Server Instance These steps leads to installation of gateway to the on-prem server that links to ADF (Self-Hosted IR)
upvoted 1 times
...
sonu_agrawal
4 years, 1 month ago
What is the correct answer for this?
upvoted 1 times
...
joguerra
4 years, 3 months ago
You don't need to pick "Configure on-premises SQL Server Instance ... " because self-host runtime already does that. Look at the tuturial, you don't need to touch anything related to SQL Server Instance, you simply create a linked service through the self-host IR. I would say it is redundant. Creating a VPN on the otherside, (although not mandatory) makes the solution more complete.
upvoted 4 times
...
syu31svc
4 years, 5 months ago
I would say the answer given is correct VPN to establish connection as the first step followed by creating Azure Data Factory and configure self-hosted integration runtime
upvoted 3 times
...
groy
4 years, 7 months ago
1: Deploy an Azure Data Factory 2: From the on-premises network, install and configure a self-hosted runtime. 3: Configure a linked service to connect to the SQL Server instance.
upvoted 2 times
BRW
4 years, 3 months ago
Without link service there is no way to connect SQL Server from ADF. I guess this option is missing.
upvoted 1 times
...
...
ExamPwnr
4 years, 7 months ago
1. Create an Azure Data Factory resource 2. Configure a self-hosted integration runtime (configure means that you have ADF already running) 3. Configure the on-premises SQL server instance with an integration runtime (means that you go into ADF and connect to the database using IR) You don't need VPN - all communication from IR to ADF is over HTTPS
upvoted 7 times
dumpsm42
4 years, 4 months ago
hi to all, this is the right answer 4 sure. please see this link, all the steps are there: https://docs.microsoft.com/pt-pt/azure/machine-learning/team-data-science-process/move-sql-azure-adf vpn no needed, the IR onpremises uses https as default regards
upvoted 1 times
dumpsm42
4 years, 4 months ago
Create an Azure Data Factory The instructions for creating a new Azure Data Factory and a resource group in the Azure portal are provided Create an Azure Data Factory. Name the new ADF instance adfdsp and name the resource group created adfdsprg. Install and configure Azure Data Factory Integration Runtime The Integration Runtime is a customer-managed data integration infrastructure used by Azure Data Factory to provide data integration capabilities across different network environments. This runtime was formerly called "Data Management Gateway". To set up, follow the instructions for creating a pipeline Create linked services to connect to the data resources A linked service defines the information needed for Azure Data Factory to connect to a data resource. We have three resources in this scenario for which linked services are needed: On-premises SQL Server Azure Blob Storage Azure SQL Database
upvoted 1 times
...
...
...
Abhitm
4 years, 11 months ago
1: Create an Azure Data Factory 2: Configure a self-hosted integration runtime 3: Backup the DB and send it to Azure Blob storage
upvoted 4 times
maciejt
3 years, 11 months ago
That's why you have ADF to use copy activity directly from table to blob, and you don't need to manually copy a backup to storage
upvoted 1 times
...
...
Luke97
4 years, 11 months ago
VPN is not a mandatory requirement for self-hosted IR. It is only needed when to perform data integration securely in a private network environment, which doesn't have a direct line-of-sight from the public cloud environment. (https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime). So, the correct answers should be 1. Create an ADF; 2. Create a self-hosted IR; 3. Install and configure self-hosted IR on on-premise server;
upvoted 5 times
...
TheCyanideLancer
4 years, 11 months ago
Is VPN really a necessity?
upvoted 1 times
kilowd
4 years, 8 months ago
The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network.
upvoted 1 times
...
...
zenomas
5 years, 1 month ago
Step 1 and 2 can be in any order.
upvoted 2 times
...
AAJ
5 years, 1 month ago
Given answer is correct
upvoted 5 times
...
MilindD
5 years, 2 months ago
correct VPN is not needed
upvoted 2 times
kilowd
4 years, 8 months ago
The installation of a self-hosted integration runtime needs an on-premises machine or a virtual machine inside a private network.
upvoted 1 times
...
...
epgd
5 years, 5 months ago
The answer could be Step 1: Create an Azure Data Factory You need to create a data factory and start the Data Factory UI to create a pipeline in the data factory. Step 2: Configure a self-hosted integration runtime Step 3: Configure a self-hosted integration runtime. ?¿?
upvoted 6 times
Kampai787
4 years, 6 months ago
Tu ere loko o k
upvoted 9 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago