Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 7 question 3 discussion

Actual exam question from Microsoft's DP-201

Question #: 3
Topic #: 7

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

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

Submit Cancel

BobFar

Highly Voted 4 years 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

4 years 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, 12 months ago

Agree this is 100% correct.

upvoted 1 times

...

Ashwat_Thama

2 years, 8 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, 3 months 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, 1 month ago

"Daily inventory data comes from a Microsoft SQL server located on a private network." -> self-hosted

upvoted 11 times

ZodiaC

3 years, 12 months ago

Agree its SELF-HOSTED the FIRST one, 100% Correct.

upvoted 1 times

...

knightkkd

4 years, 8 months ago

Shouldn't it be tumbling window as we should get daily inventory?

upvoted 2 times

essdeecee

4 years, 8 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, 3 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, 1 month ago

I agree, should be event based

upvoted 6 times

...

ZodiaC

3 years, 12 months ago

AGREE, its EVENT-BASED TRIGGER 100%!

upvoted 1 times

...