Correct Answer: AWS Database Migration Service (DMS)
AWS DMS supports both full-load and Change Data Capture (CDC) to keep the target database in sync with the source until the final cutover, minimizing downtime....
Correct Answer
AWS Database Migration Service (DMS)
Why This Answer Is Correct
AWS DMS supports both full-load and Change Data Capture (CDC) to keep the target database in sync with the source until the final cutover, minimizing downtime.
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?
You are designing a high-availability multi-tier web application. You want to ensure that if an entire Availability Zone (AZ) fails, your application automatically recovers with zero data loss for the database. Which RDS configuration 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?