AZ-305 Question 101
Single answerYour organization has multiple on-premises and cloud-based relational databases that you need to regularly integrate into Azure Data Lake Storage for advanced analytics in Azure Synapse Analytics. You want to schedule daily transfers of large volumes of data, transform it in transit, and ensure secure communication with on-premises systems. Which solution should you recommend to orchestrate and automate this data integration process?
- A
Use Azure Data Factory with a self-hosted Integration Runtime
- B
Implement Azure Logic Apps with integration triggers
- C
Migrate databases using Azure Database Migration Service
- D
Set up Azure Event Grid to publish changes in real time
Show answer and explanation
Correct answer: A
Explanation
For ongoing, scheduled data integration and transformation at scale, Azure Data Factory is the recommended service. It provides a Managed and Self-Hosted Integration Runtime to securely connect to various data sources, including on-premises databases, and move the data into Azure Data Lake Storage. This approach follows Microsoft’s best practices for hybrid data integration as documented here: https://learn.microsoft.com/azure/data-factory/introduction.
- A. Correct.
Azure Data Factory with a self-hosted Integration Runtime is the correct choice because it supports secure, large-scale data movement and transformation across hybrid environments. The self-hosted IR can connect to on-premises or private network sources, then orchestrate and schedule transformation pipelines to move the data into Azure Data Lake Storage.
- B. Incorrect.
Azure Logic Apps is designed primarily for workflow automation and event-based triggers, rather than large-scale data orchestration. While it can connect to various data endpoints, it’s more suited for business process automation or simple real-time integrations rather than heavy ETL/ELT workloads.
- C. Incorrect.
Azure Database Migration Service is focused on migrating entire databases to Azure rather than orchestrating ongoing data integration pipelines. It’s not intended for continuous transformations and scheduled integration tasks.
- D. Incorrect.
Azure Event Grid is used to manage event-driven communication between services. It’s well-suited for broadcasting and reacting to events in real time, but it’s not designed for orchestrating large-scale, scheduled data imports or transformations.