You store web access log files in Azure Blob Storage and need an automated monthly process to load that data into Azure SQL Database for reporting. Which service should you use to orchestrate and perform the monthly upload?
Choose an answer
Tap an option to check your answer.
Correct answer: Azure Data Factory.
Why this is the answer
Azure Data Factory (ADF) is the correct choice because it is a cloud-based ETL (Extract, Transform, Load) and data integration service that allows you to create, schedule, and orchestrate data workflows. It can connect to various data sources, including Azure Blob Storage, and load data into destinations like Azure SQL Database, making it ideal for automated, recurring data movement and transformation tasks. Microsoft SQL Server Migration Assistant (SSMA) and Data Migration Assistant (DMA) are tools primarily designed for migrating existing on-premises SQL Server databases to Azure SQL Database or other SQL platforms, not for ongoing data ingestion from Blob Storage. AzCopy is a command-line utility for high-performance data transfer to and from Azure storage, but it lacks the orchestration, scheduling, and transformation capabilities required for an automated monthly ETL process.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed