SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is migrating a legacy application that uses an Oracle database to AWS. The application is critical and requires high availability with automatic failover. The company wants to use Amazon RDS for Oracle. The database size is 200 GB. The company needs a solution that provides automatic failover to a standby instance in a different Availability Zone with minimal downtime. Which RDS deployment option should the company use?
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
✓
Multi-AZ deployment
Multi-AZ deployment. Multi-AZ deployment for Amazon RDS automatically provisions and maintains a standby replica in a different Availability Zone. In the event of a failure, Amazon RDS automatically fails over to the standby, resulting in minimal downtime. Option A is incorrect because Multi-Region with Read Replicas is designed for read scaling and disaster recovery, not automatic failover with minimal downtime. Option B is incorrect because Single-AZ with Oracle Data Guard requires manual setup and management, and does not provide the same level of automated failover as Multi-AZ. Option C is incorrect because Single-AZ deployment lacks a standby instance; automatic backups do not provide failover capability.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Multi-Region deployment with Read Replicas
Why it's wrong here
Read Replicas do not provide automatic failover.
- ✗
Single-AZ deployment with Oracle Data Guard
Why it's wrong here
Data Guard is not natively managed by RDS; requires manual setup.
- ✗
Single-AZ deployment with automatic backups
Why it's wrong here
No failover; backups are for point-in-time recovery.
- ✓
Multi-AZ deployment
Why this is correct
Multi-AZ provides automatic failover with a standby in a different AZ.
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.