You store web access logs data in Azure Blob storage. You plan to generate monthly reports from the access logs. You need to recommend an automated process to upload the data to Azure SQL Database eve

The correct answer is A. Azure Data Factory. Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and

Submitted by neha2k· Mar 6, 2026Process and manage data

Question

You store web access logs data in Azure Blob storage. You plan to generate monthly reports from the access logs. You need to recommend an automated process to upload the data to Azure SQL Database every month. What should you include in the recommendation?

Options

AAzure Data Factory
BData Migration Assistant
CMicrosoft SQL Server Migration Assistant (SSMA)
DAzCopy

How the community answered

(24 responses)

A
71% (17)
B
8% (2)
C
4% (1)
D
17% (4)

Explanation

Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and schedule data-driven workflows (called pipelines) that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL https://docs.microsoft.com/en-gb/azure/data-factory/introduction

Topics

#Azure Data Factory#ETL pipeline#Blob storage#automated data transfer

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice