Examkin

Question

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

A city is deploying a traffic management system that receives real-time telemetry data from thousands of road sensors. The data is semi-structured and must be stored in a non-relational format. The development team wants to query this data using a Cassandra API, and requires a service where Microsoft automatically manages the database engine updates and operating system patching. Which Azure service should the city implement?

  1. A
    Azure SQL Database
  2. B
    SQL Server on Azure Virtual Machines
  3. Azure Cosmos DBAnswer
  4. D
    Microsoft 365

Answer

Azure Cosmos DB
The correct option is Azure Cosmos DB. It is a fully managed Platform as a Service (PaaS) database offering that supports multiple NoSQL APIs, including the Cassandra API. Because it is a PaaS service, Microsoft is responsible for managing the underlying hardware, operating system, and database software patching.

Step-by-Step Solution

1
Analyze the data structure and API requirements: the data is semi-structured (non-relational) and needs to be accessed via the Cassandra API.
This narrows the database choices to Azure services that support NoSQL multi-model capabilities, primarily Azure Cosmos DB.
Azure Cosmos DB is Microsoft's globally distributed, multi-model database service supporting NoSQL APIs like Cassandra.
2
Evaluate the management and patching requirements: the solution requires Microsoft to handle operating system and database engine patching.
This confirms that a Platform as a Service (PaaS) database offering is needed, ruling out Infrastructure as a Service (IaaS) Virtual Machines.
Under the shared responsibility model, PaaS offerings transfer the burden of OS updates and database patching to Microsoft.

Key Concept

Azure Cosmos DB is a fully managed PaaS NoSQL database service supporting multi-model APIs (such as Cassandra) and automatic patching.
Estimated Time:1m 0s
Rate this question

Topics

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

More questions from this topic