Designing Azure Infrastructure Solutions — Question 86

You have 12 on-premises data sources that contain customer information and consist of Microsoft SQL Server, MySQL, and Oracle databases.

You have an Azure subscription.

You plan to create an Azure Data Lake Storage account that will consolidate the customer information for analysis and reporting.

You need to recommend a solution to automatically copy new information from the data sources to the Data Lake Storage account by using extract, transform and load (ETL). The solution must minimize administrative effort.

What should you include in the recommendation?

Answer options

Correct answer: A

Explanation

Azure Data Factory is specifically designed for data integration and ETL processes, allowing automated data movement from various sources to Azure services like Data Lake Storage. The other options, such as Azure Data Explorer, Azure Data Share, and Azure Data Studio, do not provide the same level of automation or focus on ETL capabilities, making them less suitable for this scenario.