Microsoft Azure Architect Design (2020, legacy) — Question 50

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?

Answer options

• A. Data Migration Assistant
• B. Microsoft SQL Server Migration Assistant (SSMA)
• C. Azure Data Factory
• D. AzCopy

Correct answer: C

Explanation

The correct choice is Azure Data Factory, as it is designed for creating data workflows and automating data movement between services, like from Azure Blob Storage to Azure SQL Database. The other options, such as Data Migration Assistant and SSMA, are primarily for database migrations rather than scheduled data uploads, while AzCopy is a tool for transferring data but does not provide the automation for monthly reporting.