DOP-C02 Question 159
Select 3You are working as a DevOps Engineer for a global company that runs a customer-facing application on Amazon RDS for PostgreSQL. To ensure maximum availability and minimal downtime during maintenance or regional failures, what should you implement?
- A
Enable Multi-AZ deployments for the Amazon RDS instance.
- B
Use Amazon RDS Read Replicas in a different Region and promote one during a failure.
- C
Configure automatic backups and snapshots for the database.
- D
Deploy the RDS cluster in multiple Regions using AWS Global Database.
- E
Use Elastic Load Balancing (ELB) to distribute traffic among RDS instances.
Show answer and explanation
Correct answers: A, B, D
Explanation
To achieve high availability for Amazon RDS, you can use Multi-AZ deployments to ensure redundancy within a Region, AWS Global Database for multi-Region setups, and Read Replicas in a different Region for disaster recovery. These techniques together provide robust solutions for minimizing downtime and maintaining availability during failures or maintenance events.
- A. Correct.
Multi-AZ deployments provide high availability by automatically failing over to a standby instance in a different Availability Zone in case of maintenance or failures. This ensures minimal downtime.
- B. Correct.
Using Read Replicas in a different Region can provide disaster recovery and high availability. You can promote a Read Replica to a standalone database in case the primary instance becomes unavailable.
- C. Incorrect.
While automatic backups and snapshots are important for data recovery, they do not directly contribute to high availability as they only allow restoration of data rather than maintaining continuous availability.
- D. Correct.
AWS Global Database spans multiple Regions, allowing applications to read and write data with low latency in different Regions. This is an effective solution for high availability and disaster recovery.
- E. Incorrect.
Elastic Load Balancing (ELB) is used to distribute traffic among compute resources like EC2 or ECS tasks, not Amazon RDS instances. It is irrelevant to database high availability.