Automated Process to Upload Web Access Logs to Azure SQL Database | Exam AZ-304
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.C
Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and schedule data-driven workflows (called pipelines) that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL Database.
https://docs.microsoft.com/en-gb/azure/data-factory/introductionThe most suitable option for the given scenario is C. Azure Data Factory.
Azure Data Factory is a cloud-based data integration service that allows users to create data-driven workflows for orchestrating and automating data movement and transformation. It provides a platform to create, schedule, and manage data pipelines that move and transform data from various sources to destinations, including Azure Blob Storage and Azure SQL Database.
In this scenario, the access logs data is stored in Azure Blob storage, and the requirement is to upload it to Azure SQL Database every month. To automate this process, we can create a data pipeline using Azure Data Factory that copies the access logs data from Azure Blob storage to Azure SQL Database every month.
Azure Data Factory provides several pre-built connectors for various data sources and destinations, including Azure Blob Storage and Azure SQL Database. These connectors make it easy to create data pipelines without writing any code.
We can create a pipeline using Azure Data Factory that copies data from Azure Blob storage to Azure SQL Database. We can schedule the pipeline to run every month at a specific time using the scheduling feature of Azure Data Factory.
Therefore, the correct answer is C. Azure Data Factory. Options A, B, and D are not suitable for this scenario as they are not designed for automating data movement between Azure Blob storage and Azure SQL Database. Data Migration Assistant and Microsoft SQL Server Migration Assistant (SSMA) are designed for migrating data from on-premises databases to Azure SQL Database. AzCopy is a command-line tool for copying data to and from Azure Blob storage.
