DBS-C01 Workload-Specific Database Design Practice Question
A company is migrating an on-premises Oracle database to AWS. The database is 5 TB and supports a critical OLTP application with high transaction rates. The application requires stored procedures, triggers, and strong consistency. Which AWS database service is most appropriate with minimal application changes?
⚠ Common exam trap
The DBS-C01 exam often tests the misconception that any AWS-managed database can replace Oracle with minimal changes, but the trap here is that candidates overlook the critical dependency on Oracle-specific PL/SQL stored procedures and triggers, which are not directly portable to PostgreSQL, DynamoDB, or Redshift.
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 most appropriate choice because it provides native Oracle compatibility, supporting stored procedures, triggers, and strong consistency with minimal application changes. The company can use Oracle's PL/SQL code directly, and RDS for Oracle offers full ACID compliance for OLTP workloads, avoiding the need to rewrite application logic or adapt to a different consistency model.
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 Aurora PostgreSQL
Why it's wrong here
Requires application changes for Oracle compatibility.
- ✗
Amazon DynamoDB
Why it's wrong here
Does not support stored procedures or triggers natively.
- ✓
Amazon RDS for Oracle
Why this is correct
Fully compatible with Oracle, minimal changes needed.
- ✗
Amazon Redshift
Why it's wrong here
Not designed for OLTP workloads.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on DBS-C01
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company is migrating an on-premises Oracle OLTP workload to AWS. The database has complex stored procedures and requires minimal code changes. Which AWS database service is the most suitable target?
easy- A.Amazon Redshift
- B.Amazon DynamoDB
- C.Amazon Aurora PostgreSQL
- ✓ D.Amazon RDS for Oracle
Why D: Amazon RDS for Oracle is the most suitable target because it provides native Oracle compatibility, allowing the existing complex stored procedures and PL/SQL code to run with minimal or no changes. This minimizes migration risk and effort, which is the primary requirement for an OLTP workload with complex stored procedures.
Variation 2. A company is migrating an on-premises Oracle database with complex stored procedures and triggers to AWS. They want to minimize code changes. Which two AWS database services should they consider? (Choose two.)
medium- A.Amazon DynamoDB
- ✓ B.Amazon RDS for Oracle
- C.Amazon S3
- D.Amazon Redshift
- E.Amazon Aurora PostgreSQL with Babelfish
Why B: Amazon RDS for Oracle is the most direct migration target because it uses the same Oracle Database engine, allowing existing stored procedures, triggers, and PL/SQL code to run with minimal or no modification. Amazon Aurora PostgreSQL with Babelfish is not suitable for Oracle migrations because Babelfish provides compatibility with SQL Server T-SQL, not Oracle PL/SQL. Therefore, only RDS for Oracle minimizes code changes for Oracle stored procedures.
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.