AZ-305 Question #219: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• A. 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.
• B. 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.
• C. 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.

Concept tested. Azure Synapse Analytics capabilities and integrated features

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

No community discussion yet for this question.