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 C. Azure Data Factory. Azure Data Factory Data Migration Assistant (DMA * Microsoft SQL Server Migration Assistant (SSMA) You can create Data Factory pipelines that copies data from Azure Blob Storage to Azure SQL Database. The configuration pattern applies to copying from a file-based data store to a

Submitted by amina.ke· Mar 6, 2026Design data storage solutions

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

AStorage Mover
BMicrosoft SQL Server Migration Assistant (SSMA)
CAzure Data Factory
DAzCopy

How the community answered

(30 responses)

A
13% (4)
B
7% (2)
C
77% (23)
D
3% (1)

Explanation

Azure Data Factory * Data Migration Assistant (DMA * Microsoft SQL Server Migration Assistant (SSMA) You can create Data Factory pipelines that copies data from Azure Blob Storage to Azure SQL Database. The configuration pattern applies to copying from a file-based data store to a relational Create a data factory. Create Azure Storage and Azure SQL Database linked services. Create Azure Blob and Azure SQL Database datasets. Create a pipeline contains a Copy activity. Start a pipeline run. Monitor the pipeline and activity runs. https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net

Community Discussion

No community discussion yet for this question.

Full AZ-305 Practice