Microsoft Azure Architect Design (AZ-304) Practice Test

Which Azure service would you recommend to automate uploading web access logs from Azure Blob storage to Azure SQL Database monthly?

1. AzCopy

2. Microsoft SQL Server Migration Assistant

3. Azure Data Factory

4. Data Migration Assistant

The correct answer is: Azure Data Factory

The recommendation of using Azure Data Factory for automating the monthly upload of web access logs from Azure Blob storage to Azure SQL Database is well justified. Azure Data Factory is a powerful data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and transformation. With Azure Data Factory, you can easily schedule and automate the movement of data from one service to another, which aligns perfectly with the requirement of uploading logs on a monthly basis. It supports various data formats and storage services, making it suitable for extracting logs stored in Azure Blob storage, transforming them as necessary, and loading them into Azure SQL Database seamlessly. Additionally, Azure Data Factory provides monitoring and management capabilities, which can be very beneficial for overseeing the scheduled tasks and ensuring that the uploads occur as planned without manual intervention. The orchestration capabilities also allow for handling various dependencies and complexities that may arise in data processing workflows. While AzCopy is a command-line tool for copying data to and from Azure storage, it does not provide the same level of automation, particularly for integration into a monthly schedule. The Microsoft SQL Server Migration Assistant and Data Migration Assistant are primarily intended for migrating databases and do not focus on the ongoing process of transferring and automating data uploads. Therefore,