Exam AZ-304 topic 2 question 64 discussion

Actual exam question from Microsoft's AZ-304

Question #: 64
Topic #: 2

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?

A. Data Migration Assistant
B. Microsoft SQL Server Migration Assistant (SSMA)
C. Azure Data Factory
D. AzCopy

Show Suggested Answer

Suggested Answer: 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.
Reference:
https://docs.microsoft.com/en-gb/azure/data-factory/introduction

by syu31svc at Oct. 1, 2021, 11:09 a.m.