Correct Answer: RDS Multi-AZ with synchronous replication
Multi-AZ RDS maintains a standby instance in a different AZ and uses synchronous replication to ensure that if the primary fails, the standby is up to date and can take over automa...
Correct Answer
RDS Multi-AZ with synchronous replication
Why This Answer Is Correct
Multi-AZ RDS maintains a standby instance in a different AZ and uses synchronous replication to ensure that if the primary fails, the standby is up to date and can take over automatically.
This question evaluates your knowledge of Amazon RDS — a core concept tested in AWS Certified Solutions Architect – Professional (SAP-C02). Understanding Amazon RDS is essential for designing scalable, secure, and cost-effective cloud architectures. Mastery of this topic will help you answer scenario-based questions confidently on exam day.
A financial application requires a relational database that supports high availability and automated backups. The database must be fully managed to reduce operational overhead. Which service fits these requirements?
You are designing a disaster recovery solution for a mission-critical SQL Server database running on Amazon RDS. The business requirements specify a Recovery Time Objective (RTO) of 30 minutes and a Recovery Point Objective (RPO) of 5 minutes. Which RDS feature should you use?
A global gaming company needs a database that can handle multi-region writes with strong consistency and sub-second failover in the event of a regional outage. Which RDS-based service provides this capability?
You are designing a high-traffic API that uses AWS Lambda. You want to ensure that your database (Amazon RDS) is not overwhelmed by too many concurrent connections during traffic spikes. What is the most architectural way to handle this?
A travel website experiences unpredictable traffic spikes. They use an Amazon Aurora database. How can they ensure that the database tier scales automatically for both read and write workloads without manual intervention?