DP-203 Certification Practice Question #291

Question

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:

Accepted Answer

The source SQL Server is on a private/on-premises-style network, so Data Factory needs a self-hosted integration runtime for connectivity. The requirement is a regular inventory import, which fits a schedule trigger, and the actual movement of data into ADLS Gen2 is done with a Copy activity. Tumbling window and event-based triggers are distractors for different orchestration patterns.

More DP-203 practice questions