Monthly Data Upload to Azure SQL Database
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?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.B
For uploading data from Azure Blob storage to Azure SQL Database every month, the recommended solution is to use Azure Data Factory (Option B).
Azure Data Factory is a fully-managed cloud-based data integration service that allows you to create, schedule, and manage data integration pipelines to move and transform data. With Azure Data Factory, you can easily move data between various data stores and data processing services.
In this scenario, Azure Data Factory can be used to create a pipeline that moves data from Azure Blob storage to Azure SQL Database. The pipeline can be scheduled to run monthly and can include data transformation and mapping as needed.
The other options listed are not the best fit for this scenario:
A. Microsoft SQL Server Migration Assistant (SSMA): SSMA is a tool for migrating on-premises databases to Azure SQL Database or SQL Server, but it is not designed for moving data from Azure Blob storage.
C. Data Migration Assistant: Data Migration Assistant is also a tool for migrating on-premises databases to Azure SQL Database or SQL Server, but it is not designed for moving data from Azure Blob storage.
D. AzCopy: AzCopy is a command-line utility that can be used to copy data to and from Azure Blob storage, but it does not provide the scheduling and automation capabilities needed for this scenario.
