Exam DP-203 All Questions

View all questions & answers for the DP-203 exam

Exam DP-203 topic 6 question 1 discussion

Actual exam question from Microsoft's DP-203

Question #: 1
Topic #: 6

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

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

Submit Cancel

AzureJobsTillRetire

Highly Voted 1 year, 8 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, 6 months ago

agree with you

upvoted 2 times

...

ArvindK06

Highly Voted 2 years, 9 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

1 year 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, 5 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 11 months, 1 week ago

Self-hosted,Schedule ,Copy data

upvoted 1 times

...

Bhuvanesh2104

1 year, 7 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

1 year, 1 month 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, 11 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

2 years 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, 7 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, 8 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

2 years, 1 month ago

maybe.... even if it is an azure resource, but in private network, we need SelfHosted

upvoted 2 times

6b7c02a

5 months 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, 8 months ago

Should it be Self-hosted as Microsoft SQL server, not Azure though?

upvoted 1 times

...

azurearmy

2 years, 9 months ago

The answers are correct.

upvoted 18 times

...

AppleVan

2 years, 10 months ago

Shouldn't it be event based?

upvoted 3 times

rikku33

2 years, 10 months ago

Schedule trigger - because daily. so the given answer is correct

upvoted 5 times

...

samko92

2 years, 9 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, 9 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, 8 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

...