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 u...
Microsoft AZ-305 Exam
Questions Number: 79 out of 268 Questions
29.48%
Question 79
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?
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 data store. Required steps: 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. Reference: https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net
