You have an Azure subscription. The subscription contains an app that is hosted in the East US, Central Europe, and East Asia regions.
You need to recommend a data-tier solution for the app. The solution must meet the following requirements:
-> Support multiple consistency levels.
-> Be able to store at least 1 TB of data.
-> Be able to perform read and write operations in the Azure region that is local to the app instance.
What should you include in the recommendation?
Click on the arrows to vote for the correct answer
A. B. C. D.C
Azure Cosmos DB approaches data consistency as a spectrum of choices. This approach includes more options than the two extremes of strong and eventual consistency. You can choose from five well-defined levels on the consistency spectrum.
With Cosmos DB any write into any region must be replicated and committed to all configured regions within the account.
Incorrect Answers:
D: Not able to do local writes.
https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels-tradeoffsDesign a Business Continuity Strategy
For the given scenario, we need to recommend a data-tier solution for an app that is hosted in different regions, and the solution should support multiple consistency levels, store at least 1 TB of data, and perform read and write operations in the Azure region local to the app instance.
Based on the requirements, the recommended solution should be able to handle large volumes of data, support multiple consistency levels, and have low latency for read and write operations to support the app instances in different regions. Here are the four options:
A. Azure SQL Database in an Elastic Pool: Azure SQL Database is a fully managed relational database service that provides high-availability, automatic scaling, and built-in intelligence to optimize performance. Elastic pools provide a way to share resources across multiple databases, enabling better resource utilization and reducing costs. While Azure SQL Database can store large amounts of data, it may not provide the performance and flexibility required to support multiple consistency levels.
B. Microsoft SQL Server Always On availability group on Azure virtual machines: Always On availability groups in SQL Server provide high availability and disaster recovery solutions. The availability groups can be deployed in Azure virtual machines to provide a highly available and scalable database solution. However, this solution requires additional management and maintenance, and may not provide the low latency and consistency required to support the app instances in different regions.
C. Azure Cosmos DB database: Azure Cosmos DB is a fully managed NoSQL database service that provides global distribution, high availability, and low latency. Cosmos DB provides multiple consistency levels, including strong consistency, bounded staleness, session consistency, and eventual consistency. Cosmos DB also supports automatic scaling, automatic indexing, and multiple APIs (SQL, MongoDB, Cassandra, Azure Table storage, Gremlin, and Azure Cosmos DB APIs). Based on the requirements, Cosmos DB is a good fit for the scenario.
D. Azure Table storage that uses geo-redundant storage (GRS) replication: Azure Table storage is a NoSQL key-value store that can store large amounts of structured data, providing low-cost storage and high availability. Table storage supports geo-replication, allowing for the replication of data across regions. However, Table storage has limited querying capabilities and does not support multiple consistency levels.
Therefore, the recommended solution that meets all the requirements mentioned in the scenario is Azure Cosmos DB database. Cosmos DB can support multiple consistency levels, store large amounts of data, and perform read and write operations with low latency in the Azure region local to the app instance.