Copyright (c) 2026 MindMesh Academy. All rights reserved. This content is proprietary and may not be reproduced or distributed without permission.

3.2.2. Selecting the Right API (Critical Exam Topic!)

💡 First Principle: Cosmos DB is a multi-model database. Selecting the correct API depends on your data model and whether you're migrating an existing application or building new.

API Selection Guide

Workload / RequirementCosmos DB APIData Model
New application / General NoSQLCore (SQL) APIDocument (JSON)
Migrating existing MongoDBMongoDB APIDocument (BSON)
Migrating existing CassandraCassandra APIWide-column
Social networks / RelationshipsGremlin APIGraph (Nodes & Edges)
Simple key-value migrationTable APIKey-Value
Visual: Cosmos DB Multi-Model Architecture
Loading diagram...

⚠️ Common Pitfall: Choosing Gremlin API for simple document storage. Gremlin is specifically for graph queries (relationships). If you just need JSON documents, use Core (SQL) API.