Microsoft Exam AZ-305 Topic 4 Question 61 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 61
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 Terrilyn at Jul 07, 2024, 04:56 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Myrtie

4 months ago

Hold up, what about Azure Data Share? Sharing data between sources and the Data Lake Storage sounds handy. But I guess Azure Data Factory is the all-in-one solution we need here.

upvoted 0 times

Royal

3 months ago

Azure Data Share is good for sharing data, but for automating the ETL process, Azure Data Factory is the best choice.

upvoted 0 times

...

Frankie

3 months ago

I think Azure Data Factory is the way to go. It can handle the ETL process efficiently.

upvoted 0 times

...

Kiera

4 months ago

Azure Data Studio? Nah, that's just a tool for managing databases, not for ETL. C'mon, guys, let's keep it simple and go with Azure Data Factory!

upvoted 0 times

Yoko

3 months ago

Azure Data Studio? Nah, that's just a tool for managing databases, not for ETL. C'mon, guys, let's keep it simple and go with Azure Data Factory!

upvoted 0 times

...

Renato

3 months ago

D) Azure Data Studio

upvoted 0 times

...

Shonda

3 months ago

C) Azure Data Share

upvoted 0 times

...

Tammara

4 months ago

B) Azure Data Explorer

upvoted 0 times

...

Novella

4 months ago

A) Azure Data Factory

upvoted 0 times

...

Aliza

4 months ago

Hmm, I'm not sure. Azure Data Explorer sounds cool, but it might be overkill for this scenario. Why complicate things when Azure Data Factory can do the job seamlessly?

upvoted 0 times

Lavelle

3 months ago

Definitely, Azure Data Factory is the best choice to minimize administrative effort in this scenario.

upvoted 0 times

...

Fletcher

3 months ago

Yeah, Azure Data Explorer might be too much for what we need. Let's keep it simple with Azure Data Factory.

upvoted 0 times

...

Fannie

3 months ago

I agree, Azure Data Factory is the way to go. It's simple and efficient.

upvoted 0 times

...

Johnetta

3 months ago

Azure Data Factory is definitely the best choice here. It will make the process easy and minimize the effort needed.

upvoted 0 times

...

Carisa

3 months ago

Yeah, Azure Data Explorer might be too much for what we need. Let's keep it simple with Azure Data Factory.

upvoted 0 times

...

Eric

4 months ago

I agree, Azure Data Factory is the way to go. It's simple and efficient.

upvoted 0 times

...

Elke

5 months ago

I think Azure Data Explorer might be a better choice for real-time analytics, but for ETL, Azure Data Factory seems like the right choice.

upvoted 0 times

...

Junita

5 months ago

I'm not sure, maybe Azure Data Share could also be a good option for sharing data between sources.

upvoted 0 times

...

Ardella

5 months ago

I agree, Azure Data Factory is the perfect choice. It's easy to set up and can automate the whole process, which is exactly what we need here.

upvoted 0 times

Sherita

4 months ago

C) Azure Data Share could also work, but I think Azure Data Factory is the best option for automating the ETL process.

upvoted 0 times

...

Izetta

4 months ago

A) Azure Data Factory is definitely the way to go. It can handle all those different data sources with ease.

upvoted 0 times

...

Cletus

5 months ago

I agree with Ilene, Azure Data Factory can automate the ETL process efficiently.

upvoted 0 times

...

Janey

5 months ago

Azure Data Factory is the way to go! It's a comprehensive ETL solution that can handle all those data sources without much manual effort.

upvoted 0 times

Carolynn

4 months ago

I've used Azure Data Factory before and it's really efficient for automating data movement tasks.

upvoted 0 times

...

Florinda

4 months ago

Azure Data Share could also be a good option for sharing data, but for ETL, Azure Data Factory is the way to go.

upvoted 0 times

...

Denna

4 months ago

I agree, it can handle multiple data sources and automate the ETL process.

upvoted 0 times

...

Van

5 months ago

Azure Data Factory is definitely the best choice for this scenario.

upvoted 0 times

...

Ilene

5 months ago

I think we should include Azure Data Factory in the recommendation.

upvoted 0 times

...