A company is deploying a new retail application in Azure that requires a relational database backend. The database design must satisfy the following requirements:
- Cost-effectively manage resource allocation for 20 databases that experience short, unpredictable spikes in usage.
- Ensure that database backups remain available even if a single datacenter within the primary region suffers a complete outage.
Which two options should you include in the design? (Select two.)
- Azure SQL Database Elastic PoolsAnswer
- Zone-redundant storage (ZRS) for backup storage redundancyAnswer
- CLocally redundant storage (LRS) for backup storage redundancy
- DAzure SQL Database Single Database deployment for each database
Answer
Azure SQL Database Elastic Pools and Zone-redundant storage (ZRS) for backup storage redundancy.
Azure SQL Database Elastic Pools are the optimal choice to manage resource allocation and cost for multiple databases with unpredictable workloads. Zone-redundant storage (ZRS) provides the required resiliency against a single datacenter outage by replicating backup data across different availability zones within the region.
Step-by-Step Solution
Key Concept
Azure SQL Database Elastic Pools and Backup Redundancy Options