Which Azure Data Factory components should you recommend using together to import the daily inventory data from SQL to Data Lake Storage?

HOTSPOT

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

View Answer

Answer:

Explanation:

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.