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…

The correct answer is D. Azure Synapse Analytics. Azure Synapse Analytics is the comprehensive solution for designing a data engineering platform that includes on-premises SQL data transfer, scheduled jobs, an Azure data warehouse, a managed Spark cluster with multi-language notebooks, and an integrated data lake.

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

How the community answered

(37 responses)
  • A
    27% (10)
  • B
    5% (2)
  • C
    14% (5)
  • D
    54% (20)

Why each option

Azure Synapse Analytics is the comprehensive solution for designing a data engineering platform that includes on-premises SQL data transfer, scheduled jobs, an Azure data warehouse, a managed Spark cluster with multi-language notebooks, and an integrated data lake.

AAzure Data Factory

Azure Data Factory is an ETL orchestration service but does not include the data warehouse, managed Spark cluster, or data lake store as an integrated analytics platform.

BAzure Databricks

Azure Databricks provides a managed Spark environment with notebooks but does not inherently include the data warehousing capabilities or full ETL orchestration and data lake store components of a complete solution.

CAzure Data Lake Gen2 Storage accounts

Azure Data Lake Gen2 Storage accounts provide the data lake storage component but do not offer data warehousing, ETL orchestration, or managed Spark clusters for analytics.

DAzure Synapse AnalyticsCorrect

Azure Synapse Analytics unifies enterprise data warehousing, big data analytics, and data integration capabilities, offering dedicated SQL pools, Apache Spark pools supporting Scala, R, and Python notebooks, and pipelines for scheduled data transfer, all integrated with Azure Data Lake Storage Gen2.

Concept tested: Azure Synapse Analytics capabilities and integrated features

Source: https://learn.microsoft.com/en-us/azure/synapse-analytics/overview-what-is

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-305 Practice