Examkin

Question

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

A software development team is designing a telemetry ingestion system. The system requires a globally distributed database that can store unstructured JSON documents and support MongoDB API compatibility. A team member suggests deploying Azure SQL Database for this workload. Why is this suggestion incorrect?

  1. Azure SQL Database is a relational database engine that does not natively support NoSQL features like MongoDB API compatibility.Answer
  2. B
    Azure SQL Database is a Software as a Service (SaaS) solution where the database schema cannot be modified.
  3. C
    Azure SQL Database is an Infrastructure as a Service (IaaS) solution that requires the customer to patch the database operating system.
  4. D
    Azure Cosmos DB is the only database service in Azure that supports SQL-based relational queries.

Answer

Azure SQL Database is a relational database engine that does not natively support NoSQL features like MongoDB API compatibility.
The option stating that Azure SQL Database is a relational database engine that does not natively support MongoDB API compatibility is correct because Azure SQL Database is designed for relational data and does not support NoSQL APIs like MongoDB API. To get MongoDB API compatibility, Azure Cosmos DB should be used instead.

Step-by-Step Solution

1
Analyze the requirements for the telemetry ingestion system.
The workload requires global distribution, unstructured JSON document storage, and MongoDB API compatibility.
Identifying the data model and API requirements is necessary to evaluate the suitability of the proposed database service.
2
Evaluate the suggested service (Azure SQL Database) against the requirements.
Azure SQL Database is a relational database service and does not support NoSQL database APIs like MongoDB API.
This shows that the suggested service does not meet the core application requirements.
3
Select the correct option detailing the mismatch.
The option explaining that Azure SQL Database is a relational engine lacking NoSQL MongoDB API compatibility is correct.
This accurately identifies why Azure SQL Database is the wrong choice for a MongoDB workload.

Key Concept

Azure SQL Database is a relational database service, whereas Azure Cosmos DB is a multi-model NoSQL database service supporting APIs like MongoDB API.
Estimated Time:1m 0s
Rate this question

Topics

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

More questions from this topic