Microsoft Certified: Azure Solutions Architect ExpertDesign infrastructure solutionsHard
A multinational corporation is implementing a new enterprise data warehouse solution in Azure. The solution needs to process petabytes of structured and unstructured data from various sources, perform complex analytical queries, and scale compute and storage independently to handle fluctuating workloads efficiently. Which Azure service is BEST suited for this data warehouse solution?
- AAzure Data Lake Storage Gen2
- BAzure Synapse Analytics
- CAzure Data Factory
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Synapse Analytics
Azure Synapse Analytics is an enterprise analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It allows processing petabytes of data, performs complex queries, and offers independent scaling of compute and storage, making it ideal for the described data warehouse requirements.
Why the other options are wrong
- A. Azure Data Lake Storage Gen2 is a storage solution for big data, but it needs an analytics engine like Azure Synapse Analytics to perform complex analytical queries and manage compute resources.
- C. Azure Data Factory is a cloud-based data integration service (ETL/ELT), used to orchestrate data movement and transformation, but it is not the data warehouse itself.
- D. Azure SQL Database is a transactional relational database and is not designed for petabyte-scale data warehousing with independent scaling of compute and storage for complex analytics.
Azure Synapse Analytics
A unified analytics platform that brings together enterprise data warehousing and big data analytics capabilities.
- Processes petabytes of structured and unstructured data.
- Independent scaling of compute and storage.
- Supports various workloads including SQL, Spark, and Data Explorer.
Memory trick: Synapse: It's the 'Synapse' that connects all your 'analytics' brainpower.