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

Exam DP-201 All Questions

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

Exam DP-201 topic 7 question 3 discussion

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

HOTSPOT -
Which Azure Data Factory components should you recommend using together to import the daily inventory data from SQL 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 nunning copy activity between a cloud data stores and a data store in private network.
Scenario: Daily inventory data comes from a Microsoft SQL server located on a private network.

Box 2: Schedule trigger -

Daily schedule -

Box 3: Copy activity -
Scenario:
Stage inventory data in Azure Data Lake Storage Gen2 before loading the data into the analytical data store. Litware wants to remove transient data from Data
Lake Storage once the data is no longer in use. Files that have a modified date that is older than 14 days must be removed.
by knightkkd at Oct. 11, 2020, 8:40 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
BobFar
Highly Voted 3 years, 10 months ago
Daily inventory data comes from a Microsoft SQL server located on a private network. self-hosted See inventory levels across the stores. Data must be updated as close to real time as possible. event-based trigger To import the daily inventory data from SQL to Azure Data Lake Storage copy activity
upvoted 9 times
KRV
3 years, 10 months ago
completely agree with BobFar , since MS SQL server on pvt network the integration run time has to be self hosted and as far as the trigger type is concerned it has to be Event based since the inventory levels are expected to be updated closer to real time as possible
upvoted 1 times
...
ZodiaC
3 years, 10 months ago
Agree this is 100% correct.
upvoted 1 times
...
Ashwat_Thama
2 years, 6 months ago
the event based trigger can be scheduled for only storage events, and here we are moving data from sql to ADLS gen 2. so i think the given answers are correct.
upvoted 1 times
...
...
AlexD332
Most Recent 4 years, 1 month ago
From data lake to analytical store - Azure IR, data must be updated as close to real time as possible - event base, copy
upvoted 2 times
anamaster
4 years ago
"Daily inventory data comes from a Microsoft SQL server located on a private network." -> self-hosted
upvoted 11 times
ZodiaC
3 years, 10 months ago
Agree its SELF-HOSTED the FIRST one, 100% Correct.
upvoted 1 times
...
...
...
knightkkd
4 years, 6 months ago
Shouldn't it be tumbling window as we should get daily inventory?
upvoted 2 times
essdeecee
4 years, 6 months ago
Scheduled is fine as its daily its probably at a specific time hence daily as 0200 or similar suffices. Compare to the previous where its every 8 hours. That is a better model for tumbling than this.
upvoted 7 times
nick132
4 years, 2 months ago
It says: "See inventory levels across the stores. Data must be updated as close to real time as possible." in the description.
upvoted 3 times
anamaster
4 years ago
I agree, should be event based
upvoted 6 times
...
ZodiaC
3 years, 10 months ago
AGREE, its EVENT-BASED TRIGGER 100%!
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