exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 2 question 39 discussion

Actual exam question from Microsoft's AZ-305
Question #: 39
Topic #: 2
[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?

  • A. Azure Data Factory
  • B. Azure Data Explorer
  • C. Azure Data Share
  • D. Azure Data Studio
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Muffay
Highly Voted 1 year, 1 month ago
Selected Answer: A
Azure Data Factory is correct. > Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects. https://learn.microsoft.com/en-us/azure/data-factory/introduction
upvoted 9 times
...
theptr
Most Recent 1 month, 4 weeks ago
Selected Answer: A
A is Correct
upvoted 1 times
...
[Removed]
3 months, 3 weeks ago
Selected Answer: A
A is correct
upvoted 1 times
...
Lazylinux
10 months, 1 week ago
Selected Answer: A
Given answer A is correct Integrate all your data with Azure Data Factory, a fully managed, serverless data integration service. Visually integrate data sources with more than 90 built-in, maintenance-free connectors at no added cost. Easily construct ETL (extract, transform, and load) and ELT (extract, load, and transform) processes code-free in an intuitive environment or write your own code. Then deliver integrated data to Azure Synapse Analytics to unlock business insights. Easy rehosting of SQL Server Integration Services to build ETL and ELT pipelines code-free with built-in Git and support for continuous integration and continuous delivery (CI/CD). Pay-as-you-go, fully managed serverless cloud service that scales on demand for a cost-effective solution. More than 90 built-in connectors for ingesting all your on-premises and software as a service (SaaS) data to orchestrate and monitor at scale.
upvoted 1 times
...
Crossfader2208
12 months ago
Selected Answer: A
TBH for the exam like this the question seems to be a bit too simple.
upvoted 2 times
...
kishoredeena
1 year, 2 months ago
Given answer is correct https://azure.microsoft.com/en-in/products/data-factory
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago