nerdexam
Microsoft

AZ-305 · Question #346

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…

The correct answer is A. Azure Data Factory. Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL)…

Submitted by satoshi_tk· Mar 6, 2026Design data storage solutions

Question

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?

Options

  • AAzure Data Factory
  • BAzure Data Explorer
  • CAzure Data Share
  • DAzure Data Studio

How the community answered

(54 responses)
  • A
    94% (51)
  • B
    4% (2)
  • D
    2% (1)

Explanation

Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load- transform (ELT), and data integration projects. https://learn.microsoft.com/en-us/azure/data-factory/introduction

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-305 Practice