DBS-C01 Workload-Specific Database Design Practice Question
A company needs to migrate an on-premises Oracle database to AWS with minimal changes to the application code. The application uses complex stored procedures and has high availability requirements. Which database service should be used?
⚠ Common exam trap
Candidates often choose Amazon Aurora PostgreSQL due to its high availability and performance, overlooking the fact that it does not support Oracle-specific stored procedures and PL/SQL, which would require costly application rewrites.
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
✓
Amazon RDS for Oracle
Amazon RDS for Oracle is the correct choice because it provides native Oracle compatibility, supporting complex stored procedures, PL/SQL, and existing application code with minimal changes. It also offers Multi-AZ deployments for high availability, meeting the requirement without requiring a complete rewrite.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Amazon RDS for Oracle
Why this is correct
RDS for Oracle provides full Oracle compatibility with Multi-AZ for high availability.
- ✗
Amazon DynamoDB
Why it's wrong here
DynamoDB is NoSQL and does not support stored procedures or Oracle compatibility.
- ✗
Amazon Redshift
Why it's wrong here
Redshift is a data warehouse, not suitable for OLTP workloads.
- ✗
Amazon Aurora PostgreSQL
Why it's wrong here
Aurora PostgreSQL would require rewriting stored procedures from PL/SQL to PL/pgSQL.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DBS-C01 question from scratch — 1,663 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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 DBS-C01 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 DBS-C01 exam.