A company must copy nightly sales extracts from an on-premises SQL Server and several SaaS APIs into a data lake, then run a transformation step only after each copy finishes. Which Azure service coordinates these steps?
Show answer and explanation
Answer: B
Azure Data Factory is a cloud integration service that orchestrates data movement and transformation through pipelines. It offers connectors to on-premises and SaaS sources, supports dependency chaining so a transformation runs after a copy completes, and can write into a data lake. Azure Monitor collects telemetry, Power BI capacity hosts reports, and Azure Virtual Desktop provides remote desktops, so none of them coordinates these data steps.
Why the other options are wrong
- A. Azure Monitor collects logs and metrics to help you observe application health. It does not copy data between systems or run transformation steps in sequence.
- C. Power BI Premium capacity provides dedicated resources for hosting and refreshing reports. It is not an orchestration service for copying extracts from many sources.
- D. Azure Virtual Desktop delivers remote desktop and app sessions to users. It has no role in moving or transforming analytical data.