An enterprise is deploying a global fleet-tracking system for international cargo ships to monitor fuel efficiency and environmental metrics. The database must support a write-intensive workload with an write-to-read ratio, ingesting data globally across the East US, West Europe, and East Asia regions. The system requires sub-10ms latency for both reads and writes, a availability SLA for both read and write operations, and must survive regional datacenter outages without data loss. Additionally, database backup data must be resilient against regional disasters. Which two configurations should you recommend to meet these requirements?
- Configure the Azure Cosmos DB account to use multi-region writes across East US, West Europe, and East Asia.Answer
- Partition the Cosmos DB container using a high-cardinality composite key consisting of the ship identifier and the transmission hour.Answer
- CPartition the Cosmos DB container using the continent code of the current location as the partition key.
- DConfigure the periodic backup storage redundancy of the Cosmos DB account to use Locally Redundant Storage (LRS).
Answer
To meet the requirements, you must configure the Azure Cosmos DB account to use multi-region writes and partition the container using a high-cardinality composite key of the ship identifier and transmission hour.
Enabling multi-region writes ensures writes are processed locally in East US, West Europe, and East Asia, keeping latency under 10ms and fulfilling the 99.999% SLA. A high-cardinality composite key of the ship identifier and transmission hour spreads data and Request Units (RUs) uniformly across physical partitions to accommodate the write-intensive telemetry stream.
Step-by-Step Solution
Key Concept
Azure Cosmos DB multi-region writes, high-cardinality partitioning, and backup redundancy options for high-availability globally distributed databases.