Microsoft Exam AZ-305 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

Ilene

4 days ago

I agree, Azure Data Factory is a great choice for ETL processes.

upvoted 0 times

...

Jarvis

4 days ago

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

upvoted 0 times

...

Mignon

18 days ago

I agree, it's the best choice for automating data movement from multiple sources to the Data Lake Storage account.

upvoted 0 times

...

Paris

19 days ago

Yes, Azure Data Factory is perfect for ETL processes with minimal administrative effort.

upvoted 0 times

...

Shawnda

20 days ago

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

upvoted 0 times

Salome

8 days ago

Agreed, let's go with Azure Data Factory for this solution.

upvoted 0 times

...

Darrel

9 days ago

I think we have a strong recommendation with Azure Data Factory included.

upvoted 0 times

...

Latonia

11 days ago

Definitely, it's a reliable tool for automating data pipelines.

upvoted 0 times

...

Cornell

11 days ago

It also has monitoring and scheduling capabilities that can help minimize administrative effort.

upvoted 0 times

...

Teddy

12 days ago

I agree, it can easily handle data movement between different sources and the Data Lake Storage account.

upvoted 0 times

...

Irma

14 days ago

Yes, Azure Data Factory is a good choice for ETL processes.

upvoted 0 times

...

Harrison

14 days ago

A) Azure Data Factory

upvoted 0 times

...