Examkin

Question

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

A company is developing a global IoT application that must store non-relational telemetry data with low latency. The application needs to query this data using MongoDB and Cassandra APIs. Additionally, the company wants to minimize administrative effort by ensuring that Microsoft manages database engine updates and operating system patching. Which Azure database service should the company select to meet these requirements?

  1. A
    Azure SQL Database, which is a Platform as a Service (PaaS) database that provides the required NoSQL APIs but requires the customer to manage and apply operating system patching.
  2. B
    Azure Cosmos DB, because it is a traditional relational database service designed primarily to enforce strict table schemas and execute complex multi-table SQL JOIN queries.
  3. Azure Cosmos DB, which is a Platform as a Service (PaaS) database that supports multi-model NoSQL APIs and automatically handles all operating system patching and software updates.Answer
  4. D
    Azure Database for PostgreSQL, which is a Software as a Service (SaaS) database offering that natively provides the MongoDB and Cassandra APIs.

Answer

Azure Cosmos DB, which is a Platform as a Service (PaaS) database that supports multi-model NoSQL APIs and automatically handles all operating system patching and software updates.
The correct option identifies Azure Cosmos DB as a Platform as a Service (PaaS) database that supports multi-model NoSQL APIs (MongoDB, Cassandra) and handles all database updates and operating system patching automatically. This aligns with the company's requirement for a non-relational database with minimal administrative overhead.

Step-by-Step Solution

1
Analyze the data model and API requirements.
The application requires a non-relational (NoSQL) database that supports MongoDB and Cassandra APIs.
This requirement points directly to Azure Cosmos DB, which is Azure's multi-model NoSQL database service.
2
Determine the cloud service model and patching responsibilities.
The company requires Microsoft to manage database updates and operating system patching, indicating a PaaS model.
In the PaaS shared responsibility model, the cloud provider manages the underlying infrastructure, operating system, and database engine updates.
3
Combine the NoSQL API and PaaS management criteria to select the correct service.
Azure Cosmos DB matches both requirements as it is a fully managed PaaS NoSQL database supporting the specified APIs.
It eliminates administrative overhead by automating updates and patching, while natively supporting MongoDB and Cassandra workloads.

Key Concept

Azure Cosmos DB features and the PaaS shared responsibility model for databases.
Rate this question

Topics

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

More questions from this topic