Microsoft Certified Azure Solutions Architect Expert · Free Practice Question Easy
Question 9
A certain company stores web access logs for one of its applications in Azure Blob storage. At the end of each month, the log data needs to be automatically sent to an Azure SQL database for report generation.
What solution would you suggest for this requirement?
-
A
Azure Data Factory
-
B
Data Migration Assistant
-
C
Microsoft SQL Server Migration Assistant (SSMA)
-
D
AzCopy
Reveal correct answer
Correct answer: A
A. Azure Data Factory is the correct solution for this requirement as it is a cloud-based data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and data transformation. It can easily connect to Azure Blob storage and Azure SQL database to transfer the log data at the end of each month for report generation.
B.
Data Migration Assistant is not the most suitable solution for this requirement as it is primarily used for assessing the compatibility of your on-premises SQL Server to a newer version. It does not provide the necessary capabilities for automating the transfer of log data from Azure Blob storage to Azure SQL database.
C. Microsoft SQL Server Migration Assistant (SSMA) is designed to help you migrate on-premises SQL Server databases to Azure SQL Database. It is not the appropriate tool for automating the transfer of log data from Azure Blob storage to Azure SQL database on a monthly basis for report generation.
D. AzCopy is a command-line utility that you can use to copy data to and from Azure Blob storage. While it can be used to transfer log data from Azure Blob storage to Azure SQL database, it does not provide the automation and orchestration capabilities needed to schedule and automate this process at the end of each month. Azure Data Factory is a more suitable solution for this requirement.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
