Designing Azure Infrastructure Solutions — Question 109

You need to recommend a data storage solution that meets the following requirements:
✑ Ensures that applications 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?

Answer options

• A. an Azure SQL Database elastic pool that uses active geo-replication
• B. tables in an Azure Storage account that use geo-redundant storage (GRS)
• C. tables in an Azure Storage account that use read-access geo-redundant storage (RA-GRS)
• D. an Azure SQL database that uses active geo-replication

Correct answer: B

Explanation

The correct answer is B because Azure Storage accounts with geo-redundant storage (GRS) provide a cost-effective solution that meets REST access requirements and supports multiple tables. Options A and D involve Azure SQL Database, which may not be as cost-effective for 20 independent tables, while option C, although similar to B, may incur higher costs due to read-access features that are unnecessary for the requirements.