Microsoft Exam AZ-305 Topic 3 Question 59 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 59
Topic #: 3

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 Maddie at Jun 24, 2024, 08:51 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Talia

4 months ago

I'm just picturing the poor admin trying to manually copy data from 12 different databases. That's a recipe for a migraine! Time to let the robots handle it.

upvoted 0 times

Allene

3 months ago

Azure Data Share is not the best option for automating ETL tasks. You should go with Azure Data Factory.

upvoted 0 times

...

Chana

3 months ago

C) Azure Data Share

upvoted 0 times

...

Pete

3 months ago

Definitely! Azure Data Factory can automate the ETL process for you.

upvoted 0 times

...

Rickie

3 months ago

A) Azure Data Factory

upvoted 0 times

...

Arlyne

3 months ago

That's a good option too, but Azure Data Factory is specifically designed for ETL tasks.

upvoted 0 times

...

Heike

4 months ago

C) Azure Data Share

upvoted 0 times

...

Heike

4 months ago

Definitely! Azure Data Factory can automate the ETL process for you.

upvoted 0 times

...

Art

4 months ago

A) Azure Data Factory

upvoted 0 times

...

Eladia

5 months ago

Azure Data Studio? That's just a SQL Server management tool. It won't help us move all this data automatically. We need a dedicated ETL service.

upvoted 0 times

Adolph

3 months ago

Great, let's go with Azure Data Factory then. It seems like the best option to minimize administrative effort.

upvoted 0 times

...

Krissy

4 months ago

Yes, Azure Data Factory is specifically designed for ETL tasks. It should be able to handle the data transfer from our various sources to the Data Lake Storage account.

upvoted 0 times

...

Brande

4 months ago

Azure Data Factory? That sounds like the right tool for automating the data transfer process.

upvoted 0 times

...

Amina

4 months ago

D) Azure Data Studio

upvoted 0 times

...

Lera

4 months ago

C) Azure Data Share

upvoted 0 times

...

Erasmo

4 months ago

B) Azure Data Explorer

upvoted 0 times

...

Chantay

5 months ago

A) Azure Data Factory

upvoted 0 times

...

Patria

5 months ago

Azure Data Share? Really? That's for sharing data, not automating data ingestion. I think we're looking for a more comprehensive solution here.

upvoted 0 times

Rashad

4 months ago

C) Azure Data Share

upvoted 0 times

...

Onita

4 months ago

A) Azure Data Factory

upvoted 0 times

...

Larue

5 months ago

I think Azure Data Factory is the best choice because it is specifically designed for ETL processes and can minimize administrative effort.

upvoted 0 times

...

Germaine

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

...

Amie

5 months ago

I agree with Evangelina, Azure Data Factory can help automate the ETL process.

upvoted 0 times

...

Tyisha

6 months ago

I'm not sure Azure Data Explorer is the best fit here. Isn't that more for querying and analyzing big data? We need something that can handle the ETL heavy lifting.

upvoted 0 times

Gilberto

5 months ago

I think Azure Data Share is more for sharing data, not for ETL tasks.

upvoted 0 times

...

Mona

5 months ago

C) Azure Data Share

upvoted 0 times

...

Lacey

5 months ago

I agree, Azure Data Factory is the best option for ETL processes.

upvoted 0 times

...

Fannie

5 months ago

B) Azure Data Share

upvoted 0 times

...

Leota

5 months ago

A) Azure Data Factory

upvoted 0 times

...

Evangelina

6 months ago

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

upvoted 0 times

...

Jerry

6 months ago

Azure Data Factory is the way to go! It's a powerful ETL tool that can connect to all those data sources and automate the data transfer to the Data Lake. Saves a ton of manual effort.

upvoted 0 times