nerdexam
Amazon

DBS-C01 · Question #117

A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Aurora. The cost for the database migration must be kept to a minimum, and both the on- premises Oracle…

The correct answer is A. Use the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema. C. Create an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster. To migrate a 2-TB Oracle database to Amazon Aurora quickly, cost-effectively, and with minimal downtime, use AWS Schema Conversion Tool (SCT) for schema conversion and AWS Database Migration Service (DMS) for continuous data replication.

Submitted by anna_se· Mar 6, 2026Deployment and Migration

Question

A company is migrating a mission-critical 2-TB Oracle database from on premises to Amazon Aurora. The cost for the database migration must be kept to a minimum, and both the on- premises Oracle database and the Aurora DB cluster must remain open for write traffic until the company is ready to completely cut over to Aurora. Which combination of actions should a database specialist take to accomplish this migration as quickly as possible? (Choose two.)

Options

  • AUse the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema.
  • BUse Oracle's Data Pump tool to export a copy of the source database schema and manually edit
  • CCreate an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster.
  • DCreate an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster.
  • ECreate an AWS Glue job and related resources to migrate data from the Oracle database to the

How the community answered

(28 responses)
  • A
    64% (18)
  • B
    4% (1)
  • D
    21% (6)
  • E
    11% (3)

Why each option

To migrate a 2-TB Oracle database to Amazon Aurora quickly, cost-effectively, and with minimal downtime, use AWS Schema Conversion Tool (SCT) for schema conversion and AWS Database Migration Service (DMS) for continuous data replication.

AUse the AWS Schema Conversion Tool (AWS SCT) to convert the source database schema.Correct

AWS Schema Conversion Tool (AWS SCT) automates the conversion of heterogeneous database schemas, stored procedures, and application code from Oracle to Amazon Aurora, which is crucial for a fast migration.

BUse Oracle's Data Pump tool to export a copy of the source database schema and manually edit

Using Oracle's Data Pump tool and manual editing is a time-consuming and error-prone process for heterogeneous schema conversion compared to AWS SCT.

CCreate an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster.Correct

AWS Database Migration Service (AWS DMS) supports continuous, near-zero-downtime migrations, allowing the on-premises Oracle database and the Aurora DB cluster to remain open for write traffic until the cutover, making it ideal for mission-critical databases.

DCreate an AWS DMS task to migrate data from the Oracle database to the Aurora DB cluster.

This is a duplicate of option C and does not represent a distinct, separate action.

ECreate an AWS Glue job and related resources to migrate data from the Oracle database to the

AWS Glue is an ETL service primarily for data integration and analytics workloads, not designed for real-time, transactional database migrations with minimal downtime.

Concept tested: Heterogeneous database migration with AWS SCT and DMS

Source: https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html

Topics

#Oracle to Aurora migration#AWS SCT#AWS DMS#heterogeneous migration#zero downtime migration#cost optimization

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DBS-C01 Practice