exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam

Exam DP-200 topic 2 question 3 discussion

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

HOTSPOT -
A company runs Microsoft Dynamics CRM with Microsoft SQL Server on-premises. SQL Server Integration Services (SSIS) packages extract data from Dynamics
CRM APIs, and load the data into a SQL Server data warehouse.
The datacenter is running out of capacity. Because of the network configuration, you must extract on premises data to the cloud over https. You cannot open any additional ports. The solution must implement the least amount of effort.
You need to create the pipeline system.
Which component should you use? To answer, select the appropriate technology in the dialog box in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Source -
For Copy activity, it requires source and sink linked services to define the direction of data flow.
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.
Box 2: Self-hosted integration runtime
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/create-self-hosted-integration-runtime

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
Pairon
Highly Voted 4 years ago
For me are: - Self Hosted IR - Sink
upvoted 17 times
...
Williammm
Highly Voted 3 years, 10 months ago
So...what is the answer??? so anoying!
upvoted 7 times
...
Nnuujj
Most Recent 1 year, 7 months ago
For me: Extract SQL data on-premises: Use Azure-SSIS Integration runtime to run SSIS packages in ADF to extract data from Dynamics. Load SQL data warehouse: Use Self-hosted integration runtime to perform operations between on premises and azure. In this case loading data using ADF to SQL Server data warehouse
upvoted 1 times
...
Marcus1612
3 years, 6 months ago
Bloc 1= Azure SSIS Integration runtine". Bloc 2 = Azure SSIS Integration runtine". The main problem is that The datacenter is running out of capacity. So we just need the cloud infrastructure with the underlying ressources (cpu, memory) to transfert data between the CRM and the Data warehouse. Since an existing SSIS package exists already, the minimum effort would be to lift and shift this exiting SSIS package to the cloud. To do that, the technology behind the scene is "Azure SSIS Integration runtine".
upvoted 3 times
...
eng1
3 years, 10 months ago
The answer is correct!
upvoted 1 times
...
vrmei
3 years, 10 months ago
Self Hosted IR for both answer https://docs.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime
upvoted 2 times
...
hoangton
3 years, 11 months ago
-Self Hosted -Self Hosted
upvoted 2 times
...
cadio30
3 years, 11 months ago
The scenario retrieves data from on-prem database and loads it to on-prem data warehouse. ADF function would be to orchestrate data and their link services would use "SELF-HOSTED" and this requires to implement gateway configuration on the server where the on-prem resides. Therefore, both SELF-HOSTED is the appropriate answer
upvoted 4 times
cadio30
3 years, 11 months ago
On second though, the question states that there is a SSIS involve and it requires minimal effort, hence, Azure SSIS and Self Hosted are the answers
upvoted 2 times
...
...
Aragorn_2021
4 years ago
- Self Hosted IR ( to transfer the data from on premise to Azure) - Azure-SSIS ( to take care of the load from source to target warehouse)
upvoted 7 times
...
Prabhakaran94
4 years ago
Correct Answer is: - Azure-SSIS integration runtime - Azure integration runtime
upvoted 4 times
...
LuBarba
4 years ago
Correct answer is: - Self Hosted IR - Sink Source: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-hybrid-copy-data-tool
upvoted 4 times
memo43
3 years, 11 months ago
source is irrelevant. for me its; self host ir azure ssis
upvoted 3 times
...
...
tucho
4 years ago
I'm not sure that "Self Hosted IR" can be the right choice for the first option. Keep in mind that on-premise data-center is already running "SQL Server Integration Services (SSIS)". Some related doc: https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime
upvoted 3 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago