You are designing a data storage solution using Azure Cosmos DB for a multi-region retail application. The application requires global distribution across three Azure regions, a 99.999% availability SLA for both reads and writes, and a 90/10 read-to-write ratio. Match each application workload to the most appropriate Azure Cosmos DB API.
- API for NoSQLA customer order catalog that requires JSON document storage and querying using SQL syntax.
- API for MongoDBA shopping cart session service migrating from an on-premises MongoDB database without changing the application logic.
- API for GremlinA recommendation engine that maps and traverses complex relationships between customers, products, and reviews.
Answer
API for NoSQL matches the customer order catalog; API for MongoDB matches the shopping cart session service migrating from MongoDB; API for Gremlin matches the recommendation engine traversing relationships.
The API for NoSQL is the native document model using SQL query syntax. The API for MongoDB supports wire-protocol compatibility for existing MongoDB codebases. The API for Gremlin supports graph databases using vertices and edges.
Step-by-Step Solution
Key Concept
Azure Cosmos DB API selection based on workload data models and compatibility requirements.