A multinational corporation is implementing a new enterprise data warehouse solution in Azure. The solution needs to process petabytes of data, support complex analytical queries, and scale compute and storage independently. Data retention policies require storing historical data for over 10 years for compliance. Which Azure service is the most cost-effective and scalable choice for this data warehouse?
- AAzure Database for PostgreSQL
- BAzure Cosmos DB
- CAzure Synapse Analytics
- DAzure SQL Database
Show answer & explanationAnswer & explanation
Correct answer: C. Azure Synapse Analytics
Azure Synapse Analytics is an enterprise analytics service that brings together data warehousing, big data analytics, and data integration. It is designed for petabyte-scale data, supports complex analytical queries, and allows independent scaling of compute and storage, making it ideal for large-scale data warehouses with long-term retention.
Why the other options are wrong
- A. Azure Database for PostgreSQL is a relational database, similar to SQL Database, and not suitable for petabyte-scale data warehousing requirements.
- B. Azure Cosmos DB is a NoSQL database optimized for transactional and low-latency access, not an analytical data warehouse for complex queries on petabytes of data.
- D. Azure SQL Database is a relational database optimized for OLTP workloads, not designed for petabyte-scale analytical data warehousing with independent scaling.
Azure Synapse Analytics
Azure Synapse Analytics is an integrated analytics service that accelerates time to insight across data warehouses and big data systems. It provides a unified experience for ingesting, preparing, managing, and serving data for immediate BI and machine learning needs.
- Enterprise data warehousing and big data analytics
- Petabyte scale, Massively Parallel Processing (MPP)
- Independent scaling of compute and storage
Memory trick: Synapse connects all your big data neurons, making sense of petabytes for smart decisions.