Summer Certification Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: force70

Microsoft Designing Microsoft Azure Infrastructure Solutions AZ-305 Question # 4 Topic 1 Discussion

Microsoft Designing Microsoft Azure Infrastructure Solutions AZ-305 Question # 4 Topic 1 Discussion

AZ-305 Exam Topic 1 Question 4 Discussion:
Question #: 4
Topic #: 1

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


B.

Azure Databricks


C.

Azure Data Lake Gen2 Storage accounts


D.

Azure Synapse Analytics


Get Premium AZ-305 Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.