exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 1 question 20 discussion

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

DRAG DROP -
Your company has an on-premises Microsoft SQL Server instance.
The data engineering team plans to implement a process that copies data from the SQL Server instance to Azure Blob storage once a day. The process must orchestrate and manage the data lifecycle.
You need to create Azure Data Factory to connect to the SQL Server instance.
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 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: From the on-premises network, install and configure a self-hosted runtime.
To use copy data from a SQL Server database that isn't publicly accessible, you need to set up a self-hosted integration runtime.
Step 3: Configure a linked service to connect to the SQL Server instance.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server https://www.mssqltips.com/sqlservertip/5812/connect-to-onpremises-data-in-azure-data-factory-with-the-selfhosted-integration-runtime--part-1/

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
memo43
4 years ago
answer with sequences is CORRECT
upvoted 4 times
...
maciejt
4 years ago
linked service ust be created after crating data factory, but SH runtime is independent, so there are many possible sequences here.
upvoted 4 times
AZ20
4 years ago
step1 and step2 mentioned in are independent of each other , only step 3 is depedent on both of them
upvoted 1 times
...
...
Psycho
4 years, 1 month ago
I've worked before with integration runtime and I've followed the steps in this order: Create Data Factory, Configure a link service, install and configure an Integration runtime
upvoted 3 times
cadio30
4 years ago
Cannot setup link service to on-premise SQL Server if the self-hosted integration runtime is not configured.
upvoted 4 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 ...