DBS-C01 Question #117: Real Exam Question with Answer & Explanation

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

Explanation

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.

Common mistakes.

• B. 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.
• D. This is a duplicate of option C and does not represent a distinct, separate action.
• E. 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

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

No community discussion yet for this question.