Microsoft AZ-305 Exam - Topic 4 Question 14 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 14
Topic #: 4

[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?

AAzure Data Factory

BData Migration Assistant

CMicrosoft SQL Server Migration Assistant (SSMA)

DAzCopy

Show Suggested 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

by Eladia at May 06, 2022, 04:31 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Luisa

4 months ago

Really? I thought SSMA was the go-to for this kind of task.

upvoted 0 times

...

Claribel

4 months ago

Wait, why not use Data Migration Assistant? Seems easier.

upvoted 0 times

...

Rebecka

4 months ago

Definitely going with Azure Data Factory. Makes sense!

upvoted 0 times

...

Pete

5 months ago

I think AzCopy would work too, but not as automated.

upvoted 0 times

...

Sommer

5 months ago

Azure Data Factory is perfect for this!

upvoted 0 times

...

Fatima

5 months ago

I practiced a similar question where we had to choose tools for data integration, and Azure Data Factory seemed to be the go-to option.

upvoted 0 times

...

Lindsay

5 months ago

I'm not entirely sure, but I remember something about AzCopy being used for transferring data. Would that work for this scenario?

upvoted 0 times

...

Junita

5 months ago

I think Azure Data Factory is the right choice here since it can automate data movement and transformation.

upvoted 0 times

...

Lai

5 months ago

I feel like Data Migration Assistant is more for migrating databases rather than automating uploads. Is that correct?

upvoted 0 times

...

Sharika

5 months ago

Hmm, I'm a bit confused on this one. I know the `rpm` command is used to manage RPM packages, but I'm not sure which specific option lists the dependencies. I'll have to think this through carefully.

upvoted 0 times

...

Pamella

5 months ago

I was confused about the specifics of the data flow diagrams. Did we cover if one needs to show user interactions as well?

upvoted 0 times

...

Kenia

5 months ago

I'm not entirely sure, but I remember something about SNMP being more about polling than pushing data.

upvoted 0 times

...

Johnna

5 months ago

I feel pretty confident about this question. The diagram clearly shows the VPN connectivity between the CE and PE routers, and the default route from PE3 to the internet. I'll select the two most appropriate conclusions based on the information given.

upvoted 0 times

...