Examkin

Question

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

An organization is designing a globally distributed web application that must store semi-structured JSON documents and support writing to multiple Azure regions simultaneously with low latency. Is the following statement true or false? The organization should use Azure SQL Database to meet these requirements because it natively supports multi-region writes and NoSQL document storage.

Answer: Answer

Answer

False
The correct answer is False because Azure SQL Database is a relational database engine and cannot host multi-region write workloads natively. Azure Cosmos DB is the correct service because it is a globally distributed NoSQL database that natively supports multi-region writes and semi-structured JSON data.

Step-by-Step Solution

1
Analyze the application requirements.
The application requires storage for semi-structured JSON documents, global distribution, and the ability to write to multiple Azure regions simultaneously.
Establishing these parameters helps identify the key features needed from the Azure database service.
2
Evaluate the capabilities of Azure SQL Database.
Azure SQL Database is a relational database engine. Although it has some support for JSON, it is not a native NoSQL document store. In addition, its active geo-replication feature only supports a single write region with read-only secondary replicas.
This step determines whether the proposed service meets the defined requirements.
3
Identify the correct Azure service that fits all requirements.
Azure Cosmos DB is a globally distributed NoSQL database service that natively supports document schemas and multi-region writes.
This confirms that the statement is false since Azure Cosmos DB, not Azure SQL Database, is the appropriate choice.

Key Concept

Relational vs. non-relational database capabilities and multi-region write support in Azure
Rate this question

Topics

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

More questions from this topic