Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft AZ-305 Exam - Topic 3 Question 95 Discussion

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) Azure Data Factory
B) Data Migration Assistant
C) Microsoft SQL Server Migration Assistant (SSMA)
D) AzCopy

Microsoft AZ-305 Exam - Topic 3 Question 95 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 95
Topic #: 3
[All AZ-305 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

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/introduction

Contribute your Thoughts:

0/2000 characters
Avery
4 days ago
I feel like AzCopy is too manual for monthly reports.
upvoted 0 times
...
Nguyet
9 days ago
Data Migration Assistant seems less relevant here.
upvoted 0 times
...
Arletta
14 days ago
Agreed! It automates data movement easily.
upvoted 0 times
...
Rebbecca
19 days ago
I think Azure Data Factory is the best choice.
upvoted 0 times
...
Carmen
25 days ago
Wait, can Azure Data Factory really handle monthly uploads?
upvoted 0 times
...
Veronika
30 days ago
Data Migration Assistant is more for one-time migrations, right?
upvoted 0 times
...
Hillary
1 month ago
I thought AzCopy was better for this?
upvoted 0 times
...
Tayna
1 month ago
Totally agree, it's perfect for automation.
upvoted 0 times
...
Lemuel
2 months ago
A) Azure Data Factory is the way to go!
upvoted 0 times
...
Mireya
2 months ago
Wait, can Azure Data Factory really handle that?
upvoted 0 times
...
Malinda
2 months ago
Data Migration Assistant seems unnecessary here.
upvoted 0 times
...
Bronwyn
2 months ago
I thought AzCopy was better for this?
upvoted 0 times
...
Junita
2 months ago
Totally agree, it's perfect for automation.
upvoted 0 times
...
Maile
2 months ago
A) Azure Data Factory is the way to go!
upvoted 0 times
...
Anika
3 months ago
I feel like Data Migration Assistant is more for assessing databases rather than automating uploads. Not sure if it applies here.
upvoted 0 times
...
Ryann
3 months ago
I practiced a similar question where Azure Data Factory was the answer for data integration tasks. It seems to fit this scenario too.
upvoted 0 times
...
Tricia
3 months ago
I'm not entirely sure, but I remember something about AzCopy being used for transferring files. Is that relevant here?
upvoted 0 times
...
Theodora
4 months ago
I think Azure Data Factory is the right choice since it can automate data movement and transformation.
upvoted 0 times
...

Save Cancel