Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsMedium
A global FinTech company is migrating its on-premises transactional processing system to Azure. The system handles millions of small, high-concurrency read/write operations per second, with strict low-latency requirements for individual transactions. Data consistency is paramount, and the solution must support ACID properties. The company anticipates rapid data growth and requires automatic scaling capabilities without manual intervention. Which Azure data storage solution is most appropriate for this scenario?
- AAzure SQL Database Hyperscale
- BAzure Table Storage
- CAzure Data Lake Storage Gen2
- DAzure Cosmos DB for NoSQL
Show answer & explanationAnswer & explanation
Correct answer: A. Azure SQL Database Hyperscale
Azure SQL Database Hyperscale is designed for large-scale relational workloads, offering high transactional throughput, low latency, and automatic scaling for compute and storage, while maintaining full ACID compliance. It is ideal for scenarios requiring traditional relational database features with extreme scalability.
Why the other options are wrong
- B. Azure Table Storage is a key-value store optimized for massive scale non-relational data, lacking ACID transactions and the relational features required.
- C. Azure Data Lake Storage Gen2 is optimized for big data analytics workloads, not high-concurrency transactional processing with ACID guarantees.
- D. Azure Cosmos DB for NoSQL is a non-relational database, while the scenario requires ACID properties typically associated with relational systems and does not explicitly state a need for a globally distributed multi-model database.
Azure SQL Database Hyperscale
A service tier for Azure SQL Database that offers highly scalable storage (up to 100 TB) and compute, designed for large relational workloads with high transactional throughput and low latency, while maintaining ACID properties.
- Scales up to 100 TB of data
- Decouples compute and storage for independent scaling
- Optimized for high transactional throughput and low latency
- Maintains full ACID compliance
Memory trick: Hyperscale handles huge data, ACID-fast, and scales like a rocket.