AZ-305 Question 105
Single answerA manufacturing company collects large volumes of structured data from an on-premises SQL database and unstructured data from IoT sensors stored in Azure Data Lake Storage. They want a single platform to orchestrate data ingestion, transform their data, run advanced analytics, and provide a data warehouse for reporting. Which Azure service should you recommend for this end-to-end data analysis solution?
- A
Azure Databricks
- B
Azure Synapse Analytics
- C
Azure HDInsight
- D
Azure Data Lake Storage
Show answer and explanation
Correct answer: B
Explanation
Azure Synapse Analytics unifies big data processing, data warehousing, and orchestration in a single service. It supports Spark-based analytics, comprehensive SQL-based querying, and tightly integrated pipelines. This end-to-end approach simplifies the architecture while maintaining flexibility for both structured and unstructured data. According to Microsoft documentation, Synapse is the recommended option for enterprise-grade analytics that require a single integrated environment (https://docs.microsoft.com/azure/synapse-analytics/).
- A. Incorrect.
Option 1: Azure Databricks is a strong platform for big data processing, data science, and machine learning using Apache Spark. However, it does not natively include all the integrated features of data warehousing, SQL queries, and pipeline orchestration within a single service. You would typically still need an additional service or integration for a fully managed data warehouse.
- B. Correct.
Option 2: Azure Synapse Analytics is designed to provide an end-to-end analytics platform. It includes data ingestion, data transformation using Apache Spark or Data Flows, a fully managed SQL-based data warehouse, serverless SQL pools, and orchestration with Synapse Pipelines. This makes it suitable for an integrated analytics solution, handling both structured and unstructured data in a single environment.
- C. Incorrect.
Option 3: Azure HDInsight is a managed open-source analytics service offering clusters for Hadoop, Spark, and other frameworks. While it can process large datasets, it does not include a fully integrated SQL data warehousing component or the unified environment that Synapse offers. It often requires additional services for data orchestration and warehousing.
- D. Incorrect.
Option 4: Azure Data Lake Storage provides a highly scalable and cost-effective data lake but does not itself offer computational or orchestration capabilities. You would need to combine Data Lake Storage with other analytics services to perform transformations, analysis, or warehouse operations.