ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 157 - AZ-305 discussion

Report
Export

You have to design a Data Engineering solution for your company. The company currently has an Azure subscription. They also have application data hosted in a database on a Microsoft SQL Server hosted in their on-premises data center server. They want to implement the following requirements Transfer transactional data from the on-premises SQL server onto a data warehouse in Azure. Data needs to be transferred every day in the night as a scheduled job A managed Spark cluster needs to be in place for data engineers to perform analysis on the data stored in the SQL data warehouse. Here the data engineers should have the ability to develop notebooks in Scale, R and Python. They also need to have a data lake store in place for the ingestion of data from multiple data sources Which of the following would the use for hosting the data warehouse in Azure?

A.
Azure Data Factory
Answers
A.
Azure Data Factory
B.
Azure Databricks
Answers
B.
Azure Databricks
C.
Azure Data Lake Gen2 Storage accounts
Answers
C.
Azure Data Lake Gen2 Storage accounts
D.
Azure Synapse Analytics
Answers
D.
Azure Synapse Analytics
Suggested answer: D
asked 02/10/2024
Charles Smith
28 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first