Cyber Monday 2024! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions

Microsoft Exam AZ-305 Topic 3 Question 59 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 59
Topic #: 3
[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

Contribute your Thoughts:

Talia
5 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
4 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
6 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
6 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
Arletta
5 months ago
I think Azure Data Share might not be the best option for this scenario. Azure Data Factory is more suitable for ETL processes.
upvoted 0 times
...
Tamra
5 months ago
C) Azure Data Share
upvoted 0 times
...
Teddy
5 months ago
Absolutely, Azure Data Factory is the best choice for automating data transfer from multiple sources to Data Lake Storage.
upvoted 0 times
...
Sanda
5 months ago
A) Azure Data Factory
upvoted 0 times
...
...

Save Cancel
az-700  pass4success  az-104  200-301  200-201  cissp  350-401  350-201  350-501  350-601  350-801  350-901  az-720  az-305  pl-300  

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77