Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft Exam AZ-305 Topic 4 Question 54 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 54
Topic #: 4
[All AZ-305 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Viola at Apr 20, 2024, 09: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
Ernie
4 days 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
...
Shoshana
9 days ago
Tricky question! I'll need to review my notes on infrastructure as code to make sure I don't miss anything important.
upvoted 0 times
...
Jacklyn
13 days 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
...
Flo
13 days 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
...
Lorrie
1 years ago
I don't think Azure Data Share is the best choice for this scenario. It's more for sharing data, not ETL.
upvoted 0 times
...
Gilma
1 years ago
But what about Azure Data Share? Could that be a potential option as well?
upvoted 0 times
...
Ilene
1 years ago
I agree, Azure Data Factory is a great choice for ETL processes.
upvoted 0 times
...
Jarvis
1 years ago
I think we should include Azure Data Factory in the recommendation.
upvoted 0 times
...
Mignon
1 years 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
1 years ago
Yes, Azure Data Factory is perfect for ETL processes with minimal administrative effort.
upvoted 0 times
...
Shawnda
1 years ago
I think we should include Azure Data Factory in the recommendation.
upvoted 0 times
Salome
1 years ago
Agreed, let's go with Azure Data Factory for this solution.
upvoted 0 times
...
Darrel
1 years ago
I think we have a strong recommendation with Azure Data Factory included.
upvoted 0 times
...
Latonia
1 years ago
Definitely, it's a reliable tool for automating data pipelines.
upvoted 0 times
...
Cornell
1 years ago
It also has monitoring and scheduling capabilities that can help minimize administrative effort.
upvoted 0 times
...
Teddy
1 years ago
I agree, it can easily handle data movement between different sources and the Data Lake Storage account.
upvoted 0 times
...
Irma
1 years ago
Yes, Azure Data Factory is a good choice for ETL processes.
upvoted 0 times
...
Harrison
1 years ago
A) Azure Data Factory
upvoted 0 times
...
...

Save Cancel