Microsoft Certified: Azure Solutions Architect ExpertDesign data storage solutionsEasy

A startup is developing a new social media application. User profiles will contain basic information (username, email) but also a list of interests, friends, and complex activity feeds. The application needs to handle millions of users, scale dynamically, and provide low-latency access to user data from various geographical locations. The data model is expected to evolve frequently. Which Azure data storage solution is most appropriate?

  1. AAzure Database for MySQL
  2. BAzure Cosmos DB (MongoDB API)
  3. CAzure SQL Database
  4. DAzure Blob Storage
Show answer & explanation

Correct answer: B. Azure Cosmos DB (MongoDB API)

Azure Cosmos DB (MongoDB API) provides a globally distributed, multi-model database service that is compatible with MongoDB drivers and tools. Its document model is highly flexible for evolving user profiles with nested data (interests, friends, activity feeds) and offers dynamic scalability and low-latency global access.

Why the other options are wrong

  • A. Azure Database for MySQL is a relational database, similar to SQL DB, and not optimal for flexible, globally distributed semi-structured data.
  • C. Azure SQL Database is a relational database and less suitable for rapidly evolving, semi-structured data models like user profiles in a social media app.
  • D. Azure Blob Storage is for unstructured object storage and lacks the querying and transactional capabilities needed for user profile data.

Azure Cosmos DB (MongoDB API)

A globally distributed, multi-model database service that allows you to use your existing MongoDB skills and tools with Azure Cosmos DB's enterprise-grade capabilities.

  • Compatible with MongoDB wire protocol.
  • Supports JSON document model, flexible schema.
  • Offers global distribution, elastic scale, and guaranteed low latency.

Memory trick: Mongo profiles scale globally, social and free.

More Design data storage solutions questions