SAP-C02 Practice Question: Accelerate Workload Migration and Modernization
A company is planning to migrate its on-premises data warehouse to AWS. The data warehouse runs on a large Oracle RAC cluster with complex stored procedures and ETL jobs. The company wants to minimize migration effort while gaining cloud benefits. Which AWS service should be used as the target?
⚠ Common exam trap
SAP-C02 often tests the misconception that RDS for Oracle is a suitable data warehouse target, but it lacks the analytical scalability of 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 Redshift
Amazon Redshift is a petabyte-scale data warehouse service that is optimized for analytical workloads and supports complex SQL queries, stored procedures, and ETL jobs. It is designed to handle large data volumes and can minimize migration effort by providing compatibility with existing SQL and ETL tools. DynamoDB is a NoSQL database not suitable for complex stored procedures, RDS for Oracle is not a data warehouse and may not scale as needed, and Aurora PostgreSQL is an OLTP database, not a data warehouse.
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 DynamoDB
Why it's wrong here
DynamoDB is a NoSQL key-value store that cannot run Oracle stored procedures or existing ETL SQL, so migration would require rewriting the warehouse. It is tempting for scalability, but it would be correct only for new, non-relational workloads without Oracle PL/SQL dependencies.
- ✗
Amazon RDS for Oracle
Why it's wrong here
Amazon RDS for Oracle does not support Oracle RAC clustering, so the existing RAC architecture cannot be reproduced; it also caps database size and lacks the warehouse-scale analytics of Redshift. It is tempting because it preserves Oracle compatibility, but Redshift is the intended target for this migration.
- ✓
Amazon Redshift
Why this is correct
Amazon Redshift is a petabyte-scale columnar data warehouse supporting SQL, stored procedures and ETL tooling, letting the company migrate with minimal refactoring while gaining managed cloud elasticity. It avoids the re-architecture effort required by serverless alternatives such as Athena.
- ✗
Amazon Aurora PostgreSQL
Why it's wrong here
Aurora PostgreSQL is a relational engine incompatible with Oracle PL/SQL stored procedures, so complex ETL jobs would need rewriting, increasing migration effort. It is tempting as a managed relational service, but it suits PostgreSQL workloads, not Oracle RAC warehouses where Redshift preserves SQL with less rework.
Go deeper
Related to this question
About these practice questions
One of 984 original SAP-C02 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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Amazon Web Services exam blueprint
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.