← SAP-C02·Amazon Web Services

Question 1,086 of 1,746

Accelerate Workload Migration and Modernization →mediumMultiple SelectObjective-mapped

Quick Answer

The correct answer involves three steps: provisioning the Aurora PostgreSQL instance with sufficient compute and storage, increasing the DB instance size during migration, and using the AWS Schema Conversion Tool (SCT) to convert the Oracle schema. This combination works because AWS DMS supports change data capture (CDC) for ongoing replication, allowing you to keep the source Oracle database live while migrating data to Aurora PostgreSQL with minimal downtime. The SCT handles schema conversion upfront, which is critical since Oracle and PostgreSQL use different data types and structures, while provisioning adequate resources and scaling up the instance during migration prevents bottlenecks and reduces the overall migration window. On the AWS Certified Solutions Architect Professional SAP-C02 exam, this scenario tests your understanding of heterogeneous database migrations and the distinction between schema conversion (SCT) and data migration (DMS). A common trap is confusing SCT with a data migration tool or assuming you must stop the source database for CDC. Memory tip: think "SCT for schema, DMS for data, scale up for speed."

SAP-C02 Practice Question: Accelerate Workload Migration and Modernization

This SAP-C02 practice question tests your understanding of accelerate workload migration and modernization. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

A company is migrating a large Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which THREE steps should the company take?

Question 1mediummulti select

Full question →

A
Use AWS Database Migration Service (DMS) with change data capture (CDC) to replicate ongoing changes.
DMS with CDC enables minimal downtime migration.
B
Use AWS Schema Conversion Tool (SCT) to perform the data migration.
Why wrong: SCT converts schema only; data migration requires DMS.
C
Convert the Oracle database to PostgreSQL first, then use AWS DMS for a homogeneous migration.
Why wrong: DMS can perform heterogeneous migration directly; no prior conversion needed.
D
Use AWS Schema Conversion Tool (SCT) to convert the Oracle schema to PostgreSQL-compatible schema.
Schema conversion is necessary for heterogeneous migration.
E
Take the source Oracle database offline to ensure data consistency during the migration.
Why wrong: DMS CDC allows online migration with minimal downtime.
F
Provision the Aurora PostgreSQL instance with sufficient compute and storage to handle the migration load.
Adequate resources improve migration performance.

Full breakdown with real-world context →

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 AWS Database Migration Service (DMS) with change data capture (CDC) to replicate ongoing changes.

Option A is correct because AWS DMS can migrate data from Oracle to Aurora PostgreSQL with minimal downtime using change data capture (CDC). Option C is correct because increasing the DB instance size during migration can improve performance and reduce migration time. Option E is correct because AWS Schema Conversion Tool (SCT) can convert the Oracle schema to PostgreSQL-compatible schema, which is necessary before migration. Option B is wrong because SCT is for schema conversion, not data migration. Option D is wrong because AWS DMS can convert data types on the fly; a homogeneous migration is not required. Option F is wrong because AWS DMS supports full load plus CDC, so you don't need to stop the source database.

Key principle: NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated.

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 AWS Database Migration Service (DMS) with change data capture (CDC) to replicate ongoing changes.
Why this is correct
DMS with CDC enables minimal downtime migration.
Related concept
Static NAT maps one inside address to one outside address.
✗
Use AWS Schema Conversion Tool (SCT) to perform the data migration.
Why it's wrong here
SCT converts schema only; data migration requires DMS.
✗
Convert the Oracle database to PostgreSQL first, then use AWS DMS for a homogeneous migration.
Why it's wrong here
DMS can perform heterogeneous migration directly; no prior conversion needed.
✓
Use AWS Schema Conversion Tool (SCT) to convert the Oracle schema to PostgreSQL-compatible schema.
Why this is correct
Schema conversion is necessary for heterogeneous migration.
Related concept
Static NAT maps one inside address to one outside address.
✗
Take the source Oracle database offline to ensure data consistency during the migration.
Why it's wrong here
DMS CDC allows online migration with minimal downtime.
✓
Provision the Aurora PostgreSQL instance with sufficient compute and storage to handle the migration load.
Why this is correct
Adequate resources improve migration performance.
Related concept
Static NAT maps one inside address to one outside address.

Common exam traps

Common exam trap: NAT rules depend on direction and matching traffic

NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.

Detailed technical explanation

How to think about this question

NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.

KKey Concepts to Remember

Static NAT maps one inside address to one outside address.
PAT allows many inside hosts to share one public address using ports.
Inside local and inside global describe the private and translated addresses.
NAT ACLs identify traffic for translation, not always security filtering.

TExam Day Tips

Identify inside and outside interfaces first.
Check whether the scenario needs static NAT, dynamic NAT or PAT.
Do not confuse NAT matching ACLs with normal packet-filtering intent.

Key takeaway

NAT direction and interface roles matter as much as the IP address mapping. Inside/outside designation controls which traffic is translated.

Real-world example

How this comes up in practice

A media company stores terabytes of video archives that are accessed once a year for audit purposes. Moving these objects to a cold storage tier (Azure Archive, S3 Glacier, or Google Nearline) costs a fraction of hot storage. Questions like this test whether you understand storage tiers, access frequency tradeoffs, and retrieval latency requirements.

What to study next

Got this wrong? Here's your next step.

Review the four NAT address types (inside local, inside global, outside local, outside global), PAT port overload, and static vs dynamic NAT use cases. Then practise related SAP-C02 NAT questions on configuration and troubleshooting.

Related SAP-C02 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Design Solutions for Organizational Complexity practice questions

Practise SAP-C02 questions linked to Design Solutions for Organizational Complexity.

Design for New Solutions practice questions

Practise SAP-C02 questions linked to Design for New Solutions.

Continuous Improvement for Existing Solutions practice questions

Practise SAP-C02 questions linked to Continuous Improvement for Existing Solutions.

Accelerate Workload Migration and Modernization practice questions

Practise SAP-C02 questions linked to Accelerate Workload Migration and Modernization.

SAA-C03 VPC practice questions

Practise SAP-C02 questions linked to SAA-C03 VPC.

SAA-C03 S3 lifecycle policy questions

Practise SAP-C02 questions linked to SAA-C03 S3 lifecycle policy questions.

SAA-C03 RDS Multi-AZ questions

Practise SAP-C02 questions linked to SAA-C03 RDS Multi-AZ questions.

SAA-C03 IAM policy practice questions

Practise SAP-C02 questions linked to SAA-C03 IAM policy.

SAA-C03 Route 53 failover questions

Practise SAP-C02 questions linked to SAA-C03 Route 53 failover questions.

SAA-C03 CloudFront practice questions

Practise SAP-C02 questions linked to SAA-C03 CloudFront.

SAA-C03 NAT gateway questions

Practise SAP-C02 questions linked to SAA-C03 NAT gateway questions.

SAA-C03 VPC endpoint questions

Practise SAP-C02 questions linked to SAA-C03 VPC endpoint questions.

Practice this exam

Start a free SAP-C02 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

10 questions 20 questions 30 questions 50 questions Timed 30

SAP-C02 practice-test guide →Study guide →Browse all practice tests

FAQ

Questions learners often ask

What does this SAP-C02 question test?

Accelerate Workload Migration and Modernization — This question tests Accelerate Workload Migration and Modernization — Static NAT maps one inside address to one outside address..

What is the correct answer to this question?

The correct answer is: Use AWS Database Migration Service (DMS) with change data capture (CDC) to replicate ongoing changes. — Option A is correct because AWS DMS can migrate data from Oracle to Aurora PostgreSQL with minimal downtime using change data capture (CDC). Option C is correct because increasing the DB instance size during migration can improve performance and reduce migration time. Option E is correct because AWS Schema Conversion Tool (SCT) can convert the Oracle schema to PostgreSQL-compatible schema, which is necessary before migration. Option B is wrong because SCT is for schema conversion, not data migration. Option D is wrong because AWS DMS can convert data types on the fly; a homogeneous migration is not required. Option F is wrong because AWS DMS supports full load plus CDC, so you don't need to stop the source database.

What should I do if I get this SAP-C02 question wrong?

What is the key concept behind this question?

Static NAT maps one inside address to one outside address.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Same concept, more angles

5 more ways this is tested on SAP-C02

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 a large Oracle database to Amazon Aurora PostgreSQL. The migration must have minimal downtime and support ongoing replication. Which AWS service should the company use?

easy

A.AWS Application Discovery Service
B.AWS Server Migration Service
✓ C.AWS Database Migration Service
D.AWS Schema Conversion Tool

Why C: Option A is correct because AWS Database Migration Service (DMS) supports ongoing replication from Oracle to Aurora PostgreSQL with minimal downtime. Option B is wrong because AWS Schema Conversion Tool is used for schema conversion, not data replication. Option C is wrong because AWS Server Migration Service is for server migration, not databases. Option D is wrong because AWS Application Discovery Service is for discovery, not migration.

Variation 2. A company is migrating a large Oracle database to Amazon Aurora PostgreSQL using AWS DMS. The database is 5 TB and has frequent write operations. The migration must have minimal downtime. Which configuration should be used?

hard

✓ A.Use AWS DMS with full load and ongoing replication using CDC
B.Use AWS DataSync for the database files
C.Use AWS SCT to convert schema and then copy data manually
D.Use AWS DMS with full load only

Why A: AWS DMS ongoing replication with Change Data Capture (CDC) allows continuous syncing after the full load, minimizing downtime. Option A (only full load) causes downtime during migration. Option B (AWS SCT only) is for schema conversion, not data migration. Option C (AWS DataSync) is for file-based data, not databases.

Variation 3. A company is migrating a legacy Oracle database to Amazon Aurora PostgreSQL. The migration must be completed with minimal downtime and minimal manual effort. Which AWS service should be used?

hard

A.AWS DataSync
✓ B.AWS DMS with ongoing replication
C.AWS Snowball Edge
D.AWS Schema Conversion Tool (SCT)

Why B: Option A (AWS DMS with ongoing replication) is correct because DMS supports Oracle to PostgreSQL migration with ongoing replication for minimal downtime. Option B (SCT) is used for schema conversion, not data migration. Option C (Snowball) is for large data transfer offline. Option D (DataSync) is for file data, not databases.

Variation 4. A company is migrating a legacy Oracle database to Amazon Aurora PostgreSQL. The migration must minimize downtime and support ongoing replication. Which AWS service should the company use?

hard

A.AWS DataSync
✓ B.AWS Database Migration Service (DMS) with change data capture (CDC)
C.AWS Direct Connect
D.AWS Schema Conversion Tool (SCT)

Why B: B is correct because AWS DMS with ongoing replication can migrate data with minimal downtime. A is wrong because SCT only converts schema and code. C is wrong because DataSync is for file-based transfers. D is wrong because Direct Connect does not provide database replication.

Variation 5. A company is migrating an on-premises Oracle database to Amazon Aurora PostgreSQL. They need to minimize downtime and ensure data integrity. Which AWS service should they use for the migration?

easy

A.AWS Schema Conversion Tool (SCT)
✓ B.AWS Database Migration Service (DMS)
C.AWS DataSync
D.AWS Snowball Edge

Why B: AWS Database Migration Service (DMS) supports homogeneous and heterogeneous migrations with minimal downtime. Option A is wrong because SCT only helps with schema conversion, not the actual data migration. Option B is wrong because DataSync is for file storage. Option D is wrong because Snowball is for large-scale data transfer, not database migration.

Last reviewed: Jun 20, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

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.