Microsoft
AZ-305 · Question #219
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
Sign in or unlock AZ-305 to reveal the answer and full explanation for question #219. The question stem and answer options stay visible for context.
Submitted by fatima_kr· Mar 6, 2026Design data storage solutions
Question
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?
Options
- AAzure Data Factory
- BAzure Databricks
- CAzure Data Lake Gen2 Storage accounts
- DAzure Synapse Analytics
Unlock AZ-305 to see the answer
You've previewed enough free AZ-305 questions. Unlock AZ-305 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.