nerdexam
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.

Full AZ-305 Practice