Question 535 of 1,733
TechnologymediumMultiple ChoiceObjective-mapped

Minimal Downtime Migration: SAP ERP Oracle to AWS using DMS

This PAS-C01 practice question tests your understanding of technology. 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.

An SAP Basis administrator needs to migrate an on-premises SAP ERP system running on Oracle to AWS. The system has a 2 TB database and requires minimal downtime (less than 1 hour). The current on-premises network bandwidth to AWS is 1 Gbps. Which migration strategy is MOST appropriate?

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 ongoing replication from Oracle to Amazon RDS for Oracle, then perform a final cutover.

AWS DMS with ongoing replication from Oracle to Amazon RDS for Oracle is the most appropriate strategy because it supports minimal downtime (less than 1 hour) by continuously replicating changes from the source Oracle database to the target RDS instance, allowing a short final cutover window. The 1 Gbps bandwidth is sufficient for the initial full load of a 2 TB database when using DMS's optimized data transfer, and the target RDS for Oracle provides a fully managed Oracle-compatible environment suitable for SAP ERP workloads.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • Export the database using SAP HANA System Replication (HSR) to an Amazon EC2 instance with HANA.

    Why it's wrong here

    HSR is for HANA databases, not Oracle.

  • Perform a manual export/import using Oracle Data Pump and transfer the dump file via AWS Direct Connect.

    Why it's wrong here

    Export/import would take longer than 1 hour due to 2 TB size and 1 Gbps bandwidth.

  • Use AWS Application Migration Service (MGN) to replicate the entire server to AWS, then cut over.

    Why it's wrong here

    MGN replicates the entire OS, not optimized for database-level migration with minimal downtime.

  • Use AWS Database Migration Service (DMS) with ongoing replication from Oracle to Amazon RDS for Oracle, then perform a final cutover.

    Why this is correct

    DMS supports ongoing replication, enabling minimal downtime cutover.

    Related concept

    Read the scenario before looking for a memorised answer.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often assume a manual export/import (Option B) is the simplest approach, but they overlook the time constraint of a 2 TB database over 1 Gbps, which makes it impossible to achieve less than 1 hour downtime, while DMS's CDC capability is the key to meeting that requirement.

Detailed technical explanation

How to think about this question

AWS DMS uses Change Data Capture (CDC) via Oracle LogMiner or binary logs to capture ongoing transactions, enabling near-zero downtime migrations. For a 2 TB database, the initial full load can be parallelized across multiple tables and tasks, and the 1 Gbps link can sustain approximately 450 GB/hour under ideal conditions, meaning the full load may take 4-5 hours, but the CDC phase allows the source to remain operational during this time, with only a brief final cutover to apply remaining changes. In real-world scenarios, network latency and database write load can reduce throughput, so pre-loading with DMS's LOB handling and validation checksums is critical to avoid data corruption.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A healthcare organisation deploys an application with a public-facing web tier and a private database tier. The database subnet has no public IP and only accepts connections from the web tier's security group. Questions like this test whether you can design cloud network isolation using VNets/VPCs, subnets, and security group rules.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related PAS-C01 practice-question pages

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

Practice this exam

Start a free PAS-C01 practice session

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

FAQ

Questions learners often ask

What does this PAS-C01 question test?

Technology — This question tests Technology — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: Use AWS Database Migration Service (DMS) with ongoing replication from Oracle to Amazon RDS for Oracle, then perform a final cutover. — AWS DMS with ongoing replication from Oracle to Amazon RDS for Oracle is the most appropriate strategy because it supports minimal downtime (less than 1 hour) by continuously replicating changes from the source Oracle database to the target RDS instance, allowing a short final cutover window. The 1 Gbps bandwidth is sufficient for the initial full load of a 2 TB database when using DMS's optimized data transfer, and the target RDS for Oracle provides a fully managed Oracle-compatible environment suitable for SAP ERP workloads.

What should I do if I get this PAS-C01 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

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

Keep practising

More PAS-C01 practice questions

Last reviewed: Jul 4, 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…

Sign in to join the discussion.

This PAS-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 PAS-C01 exam.