Courseiva
Management and OperationsmediumMultiple SelectObjective-mapped

DBS-C01 Management and Operations Practice Question

A company is migrating an on-premises Oracle database to Amazon RDS for Oracle. Which TWO methods can the database specialist use to minimize downtime during the migration?

⚠ Common exam trap

Many candidates assume any backup-and-restore or export/import method (like RMAN or Data Pump) can be performed with minimal downtime, but these methods inherently require the source database to be offline or in a consistent state for a significant period, unlike continuous replication technologies such as GoldenGate or DMS with CDC.

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 Oracle GoldenGate to replicate data continuously.

Oracle GoldenGate enables continuous, real-time data replication from the source Oracle database to Amazon RDS for Oracle, allowing the source to remain fully operational during the migration. When the cutover is performed, only a brief pause is needed to apply any final transactions, minimizing downtime to seconds or minutes.

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 Oracle Recovery Manager (RMAN) to back up and restore.

    Why it's wrong here

    RMAN is not supported for RDS.

  • Use Oracle GoldenGate to replicate data continuously.

    Why this is correct

    GoldenGate provides real-time replication with minimal downtime.

  • Use AWS Database Migration Service (DMS) with ongoing replication.

    Why this is correct

    DMS with replication minimizes downtime.

  • Take a full database backup and restore to RDS.

    Why it's wrong here

    Backup and restore causes downtime.

  • Use Oracle Data Pump to export and import the database.

    Why it's wrong here

    This method requires downtime.

About these practice questions

Courseiva writes every DBS-C01 question from scratch — 1,663 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or 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 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.