SAP-C02 Design for New Solutions Practice Question
A financial services company is designing a highly available architecture for a critical application on AWS. The application runs on EC2 instances and uses an Oracle database. The database must be resilient to an Availability Zone failure and must have automated failover. Which database solution meets these requirements?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Amazon RDS for Oracle with Multi-AZ deployment.
Amazon RDS for Oracle with Multi-AZ deployment provides automatic failover to a standby instance in a different Availability Zone, meeting the requirements for high availability and automated failover. Option A is incorrect because Amazon Aurora (MySQL-compatible) is not Oracle-compatible, so it cannot replace an Oracle database. Option B is incorrect because a Read Replica in another AZ does not provide automated failover; it is used for read scaling and requires manual promotion. Option C is incorrect because deploying Oracle on EC2 with asynchronous replication requires manual failover management and does not provide automated failover.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use Amazon Aurora (MySQL-compatible) with Multi-AZ.
Why it's wrong here
Aurora is not Oracle-compatible; the application requires Oracle.
- ✗
Use Amazon RDS for Oracle with a Read Replica in another AZ.
Why it's wrong here
Read Replicas are for read scaling, not automatic failover.
- ✗
Deploy Oracle on EC2 in two Availability Zones and use asynchronous replication.
Why it's wrong here
Asynchronous replication may cause data loss; failover is manual.
- ✓
Use Amazon RDS for Oracle with Multi-AZ deployment.
Why this is correct
RDS Multi-AZ provides automatic failover and synchronous standby.
Go deeper
Related to this question
About these practice questions
This SAP-C02 question is part of Courseiva's 1,660-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This SAP-C02 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SAP-C02 exam.