Examkin

Question

Difficulty: MediumAzure Database Services (Relational, Non-Relational, and Cosmos DB)

A company is designing a globally distributed application that must store user profiles using MongoDB-compatible JSON documents and social connections using Gremlin-compatible graph queries. The company wants to ensure that Microsoft manages all database software updates and operating system patching.

Which Azure database service should the company choose?

  1. A
    Azure SQL Database
  2. Azure Cosmos DBAnswer
  3. C
    SQL Server on Azure Virtual Machines
  4. D
    Azure Database for MySQL

Answer

Azure Cosmos DB
Azure Cosmos DB is the correct answer because it is Microsoft's globally distributed, multi-model NoSQL database. It natively supports both the MongoDB API (for JSON documents) and the Gremlin API (for graph data) while running as a fully managed Platform as a Service (PaaS) where Microsoft handles all operating system patching and software updates.

Step-by-Step Solution

1
Identify the data model and API requirements.
The application requires MongoDB-compatible JSON document storage and Gremlin-compatible graph query support.
This establishes that the solution must be a multi-model NoSQL database service rather than a traditional relational database.
2
Identify the management and patching requirements.
Microsoft must manage all database updates and operating system patching, pointing to a Platform as a Service (PaaS) model.
This rules out Infrastructure as a Service (IaaS) offerings like SQL Server on Azure Virtual Machines, where the customer is responsible for OS updates.
3
Select the service that satisfies both requirements.
Azure Cosmos DB is the only PaaS database service in Azure that natively supports both MongoDB (document) and Gremlin (graph) APIs.
This matches all design and management constraints.

Key Concept

Azure Cosmos DB is a fully managed NoSQL database service that supports multiple APIs (multi-model) for flexible data access, while eliminating operating system patching overhead.
Rate this question

Topics

Azure Database Services (Relational, Non-Relational, and Cosmos DB)

More questions from this topic