SAP-C02 Question 300
Select 2A company is planning to migrate its on-premises application to AWS. The application requires high availability and low-latency access to a relational database. During peak hours, the database experiences highly variable read and write workloads. The solution should also support automated backups, scaling, and disaster recovery across multiple AWS Regions. Which combination of AWS services and configurations would best meet these requirements?
- A
Use Amazon RDS with Multi-AZ deployments for high availability and automated backups.
- B
Use Amazon Aurora Global Database to support disaster recovery across multiple Regions and low-latency read replicas.
- C
Use Amazon DynamoDB with on-demand capacity mode to handle variable workloads.
- D
Use Amazon ElastiCache to cache database queries for improved performance.
- E
Use Amazon S3 for storing relational database backups.
Show answer and explanation
Correct answers: A, B
Explanation
The combination of Amazon RDS with Multi-AZ for high availability and Aurora Global Database for disaster recovery and low-latency read replicas meets the requirements for this scenario. RDS provides automated backups and Multi-AZ deployments for fault tolerance, while Aurora Global Database ensures low-latency access and supports cross-Region disaster recovery. DynamoDB, ElastiCache, and S3 do not fulfill all the key requirements for a relational database deployment in this use case.
- A. Correct.
Amazon RDS with Multi-AZ deployments ensures high availability and automated backups, making it a suitable choice for relational database workloads.
- B. Correct.
Amazon Aurora Global Database supports disaster recovery across multiple Regions and low-latency read replicas, meeting the requirement for cross-Region disaster recovery and performance.
- C. Incorrect.
Amazon DynamoDB is a NoSQL database, which is not suitable for this relational database use case.
- D. Incorrect.
Amazon ElastiCache improves the performance of database queries but does not meet the requirements for disaster recovery, backups, or high availability of the primary database.
- E. Incorrect.
Amazon S3 is a storage service and does not provide the features required for a relational database, such as automated backups, high availability, or disaster recovery.