Microsoft AZ-305 Exam - Topic 4 Question 54 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 54
Topic #: 4

You have 12 on-premises data sources that contain customer information and consist of Microsoft SQL Server, MySQL, and Oracle databases.

You have an Azure subscription.

You plan to create an Azure Data Lake Storage account that will consolidate the customer information for analysis and reporting.

You need to recommend a solution to automatically copy new information from the data sources to the Data Lake Storage account by using extract, transform and load (ETL). The solution must minimize administrative effort.

What should you include in the recommendation?

AAzure Data Factory

BAzure Data Explorer

CAzure Data Share

DAzure Data Studio

Show Suggested Answer

Suggested Answer: A

by Viola at Apr 20, 2024, 08:45 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Giovanna

3 months ago

Really? I’m surprised it can handle all those sources so easily.

upvoted 0 times

...

Hillary

4 months ago

Azure Data Factory has great integration options too!

upvoted 0 times

...

Isabelle

4 months ago

I thought Azure Data Share was for sharing data, not ETL?

upvoted 0 times

...

Chauncey

4 months ago

Definitely agree, it's built for this kind of task.

upvoted 0 times

...

Beckie

4 months ago

Azure Data Factory is the way to go for ETL!

upvoted 0 times

...

Caitlin

4 months ago

Azure Data Share sounds familiar, but I think it’s more about sharing data rather than automating ETL tasks.

upvoted 0 times

...

Geraldine

5 months ago

I practiced a similar question where Azure Data Factory was the answer for consolidating data from multiple sources.

upvoted 0 times

...

Jeanice

5 months ago

I'm not entirely sure, but I think Azure Data Explorer is more for analytics rather than ETL.

upvoted 0 times

...

Derrick

5 months ago

I remember studying Azure Data Factory for ETL processes, it seems like the right choice for automating data movement.

upvoted 0 times

...

Yesenia

5 months ago

I'm a little confused by the options here. Azure Data Studio is more of a client tool, so I don't think that would be the right solution. I'm leaning towards Azure Data Factory, but I'll need to double-check the capabilities to make sure it meets all the requirements.

upvoted 0 times

...

Timothy

5 months ago

Hmm, I'm a bit unsure about this one. Azure Data Explorer and Azure Data Share both seem like they could potentially work, but I'm not sure if they'd be the best fit for the requirements here. I'll have to think this through carefully.

upvoted 0 times

...

Beckie

5 months ago

This looks like a classic Azure Data integration scenario. I'd recommend going with Azure Data Factory - it's designed for this exact use case of consolidating data from multiple sources into a data lake.

upvoted 0 times

...

Ernie

5 months ago

Azure Data Factory is definitely the way to go here. It's got built-in support for all the data sources mentioned, and the ETL capabilities will make it easy to automate the data consolidation process. Seems like the obvious choice to minimize administrative effort.

upvoted 0 times

...

Flo

5 months ago

This seems straightforward to me. The 'E' shows the packet reaching the external interface, and the 'i' shows it leaving the internal interface. I'm pretty confident that's the right answer.

upvoted 0 times

...

Jacklyn

5 months ago

Hmm, I'm not too familiar with Citrix ADM, so I'll have to think this through. Let me review the options and see if I can eliminate any that don't seem relevant.

upvoted 0 times

...