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

Exam DP-203 All Questions

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

Exam DP-203 topic 6 question 1 discussion

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

HOTSPOT -
Which Azure Data Factory components should you recommend using together to import the daily inventory data from the SQL server to Azure Data Lake Storage?
To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
Box 1: Self-hosted integration runtime
A self-hosted IR is capable of running copy activity between a cloud data stores and a data store in private network.

Box 2: Schedule trigger -

Schedule every 8 hours -

Box 3: Copy activity -
Scenario:
✑ Customer data, including name, contact information, and loyalty number, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table.
✑ Product data, including product ID, name, and category, comes from Salesforce and can be imported into Azure once every eight hours. Row modified dates are not trusted in the source table.
by AppleVan at Sept. 25, 2021, 4:15 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
AzureJobsTillRetire
Highly Voted 1 year, 5 months ago
Agreed with the given answers. Box1: Self-hosted integration runtime Why not Azure-SSIS integration rutime? SSIS is not mentioned, and the ETL tool in use is ADF. Why not Azure integration runtime? On-premise SQL Server database is used. Box2: Schedule trigger Why not event-based trigger? Schedule runs every 8 hours Why not tumbling window schedule? There is no requirement for a tumbling window schedule. If the ETL jobs run close to 8 hours, a tumbling window schedule may be required. If jobs need to automatically re-run on failures, a tumbling window schedule may be required. Those requirements are not there. Schedule trigger fits for purpose. Box3: Copy activity No need for explanation
upvoted 27 times
vrodriguesp
1 year, 2 months ago
agree with you
upvoted 2 times
...
...
ArvindK06
Highly Voted 2 years, 5 months ago
Should be Tumbling Window in my opinion. Since Inventory data should be updated in real time as close as possible. Only Customer & Product data are available every 8 hours.
upvoted 23 times
andjurovicela
9 months, 1 week ago
I think you are mixing up different requirements. Daily inventory, should be ingested daily, I would say and for that schedule trigger makes sense. It would make less sense to use a thumbling window, not to mention that you can't even use "day" as the first argument (time interval) for the tumbling window function when coding, only hour as the biggest measurement unit
upvoted 2 times
...
ANath
2 years, 2 months ago
I also think it should be a Tumbling Window. Because it said 'Litware will build a custom application named FoodPrep to provide store employees with the calculation results of how many prepared food items to produce every four hours.'
upvoted 3 times
...
...
kkk5566
Most Recent 7 months, 3 weeks ago
Self-hosted,Schedule ,Copy data
upvoted 1 times
...
Bhuvanesh2104
1 year, 3 months ago
The below link refers to the (a) Azure Integration Runtime: https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server
upvoted 2 times
andjurovicela
9 months, 3 weeks ago
the link you provided clearly states that virtual networks should be in place whereas the task says "Litware does not plan to implement Azure ExpressRoute or a VPN between the on-premises network and Azure." Therefore self-hosted integration runtime is the answer (as ExamTopics suggested)
upvoted 1 times
...
...
sunil_smile
1 year, 7 months ago
I think it should be SSIS integration runtime... Because currently there are SSIS pipelines which does the data integration
upvoted 2 times
...
Deeksha1234
1 year, 8 months ago
In opinion the given answer is correct since its daily inventory data, i.e. will be loaded once daily.
upvoted 3 times
...
Canary_2021
2 years, 4 months ago
Answers are correct because 'Daily inventory data comes from a Microsoft SQL server located on a private network.'.
upvoted 2 times
...
dija123
2 years, 5 months ago
I believe a Microsoft SQL server located on a private network means on Azure not on premises, which means the integration run time should be azure not self hosted.
upvoted 8 times
Davico93
1 year, 10 months ago
maybe.... even if it is an azure resource, but in private network, we need SelfHosted
upvoted 2 times
6b7c02a
1 month, 2 weeks ago
If you use azure IR with managed vnet, if you create a managed private endpoint to SQL server, it should be able to connect? Why use SHIR in this case?
upvoted 1 times
...
...
datnguye
2 years, 4 months ago
Should it be Self-hosted as Microsoft SQL server, not Azure though?
upvoted 1 times
...
...
azurearmy
2 years, 6 months ago
The answers are correct.
upvoted 18 times
...
AppleVan
2 years, 7 months ago
Shouldn't it be event based?
upvoted 3 times
rikku33
2 years, 7 months ago
Schedule trigger - because daily. so the given answer is correct
upvoted 5 times
...
samko92
2 years, 6 months ago
It is confusing cos at the top it says they want the inventory as real time as possible , but then further down it says every 8 hours. Conflicting info
upvoted 3 times
kl8585
1 year, 5 months ago
read carefully - import every 8 hours for customer date, not inventory data. Evenet triggers can be used only with storage account, so Event based is for sure wrong. It's tumbling windows
upvoted 1 times
OldSchool
1 year, 5 months ago
It says: "Daily inventory data comes from a Microsoft SQL server located on a private network." So the answer is as given: Self-hosted, Schedule, Copy
upvoted 1 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