Courseiva
← PAS-C01
Full test
Migration →mediumMultiple ChoiceObjective-mapped

PAS-C01 Migration Practice Question

A company is migrating a legacy on-premises Oracle database to Amazon RDS for Oracle. The database is 2 TB and has a 1-hour maintenance window. The company needs to minimize downtime and ensure data consistency. Which migration strategy should be used?

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 (AWS DMS) with ongoing replication from the source to the target.

AWS DMS with ongoing replication minimizes downtime by continuously replicating changes from the source to the target, allowing a cutover with minimal downtime. Native Oracle tools (Data Pump) or exporting to flat files require significant downtime, and AWS SCT only handles schema conversion.

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 (AWS DMS) with ongoing replication from the source to the target.

    Why this is correct

    AWS DMS with CDC minimizes downtime by replicating changes continuously.

  • ✗

    Use Oracle Data Pump to export and import the database during the maintenance window.

    Why it's wrong here

    Data Pump requires downtime and may not complete within 1 hour for 2 TB.

  • ✗

    Use AWS Schema Conversion Tool (AWS SCT) to convert the schema and then copy data manually.

    Why it's wrong here

    AWS SCT handles schema conversion, not data migration.

  • ✗

    Export the database to flat files, upload to Amazon S3, and then import into RDS.

    Why it's wrong here

    Exporting to flat files, uploading to S3, and importing into RDS cannot meet the 1-hour maintenance window because the export and import processes for a 2 TB database each take many hours, and the database must remain offline for the entire duration. This approach is tempting because it is a straightforward method for a one-time, offline migration when downtime is not a constraint, and it would be correct for a non-production database or a migration with a multi-day maintenance window.

About these practice questions

This PAS-C01 question is part of Courseiva's 1,616-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

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.