You need to recommend a data storage solution that meets the following requirements:
-> Ensures that application can access the data by using a REST connection
-> Hosts 20 independent tables of varying sizes and usage patterns
-> Automatically replicates the data to a second Azure region
-> Minimizes costs
What should you recommend?
Click on the arrows to vote for the correct answer
A. B. C. D.C
For the given requirements, the most suitable option would be to use Azure Storage tables with read-access geo-redundant storage (RA-GR).
Option A, an Azure SQL Database elastic database pool that uses active geo-replication, may be overkill for this use case, as it is a more powerful and expensive solution designed for large-scale enterprise applications that require high performance and scalability. It is also not a REST-based solution.
Option B, tables in an Azure Storage account that uses geo-redundant storage (GRS), provides replication to a secondary region, but does not meet the requirement for accessing data through a REST connection.
Option C, tables in an Azure Storage account that use read-access geo-redundant storage (RA-GR), satisfies all requirements. RA-GR is a cost-effective solution that provides read-only access to data in the secondary region, allowing for disaster recovery scenarios. Azure Storage tables also provide REST-based access, making them a suitable solution for this use case. The independent tables can be stored in a single storage account and partitioned by using different partition keys, ensuring optimal performance and scalability.
Option D, an Azure SQL database that uses active geo-replication, is similar to Option A, and is not as cost-effective or suitable for this use case as Option C.
Therefore, the best option for this scenario is to use tables in an Azure Storage account that uses read-access geo-redundant storage (RA-GR).