A Database Specialist Needs to Define a Database Migration Strategy

question 40

Multiple Choice

A Database Specialist needs to define a database migration strategy to migrate an on-premises Oracle database to an Amazon Aurora MySQL DB cluster. The company requires near-zero downtime for the data migration. The solution must also be cost-effective. Which approach should the Database Specialist take?

• A) Dump all the tables from the Oracle database into an Amazon S3 bucket using datapump (expdp). Run data transformations in AWS Glue. Load the data from the S3 bucket to the Aurora DB cluster.
• B) Order an AWS Snowball appliance and copy the Oracle backup to the Snowball appliance. Once the Snowball data is delivered to Amazon S3, create a new Aurora DB cluster. Enable the S3 integration to migrate the data directly from Amazon S3 to Amazon RDS.
• C) Use the AWS Schema Conversion Tool (AWS SCT) to help rewrite database objects to MySQL during the schema migration. Use AWS DMS to perform the full load and change data capture (CDC) tasks.
• D) Use AWS Server Migration Service (AWS SMS) to import the Oracle virtual machine image as an Amazon EC2 instance. Use the Oracle Logical Dump utility to migrate the Oracle data from Amazon EC2 to an Aurora DB cluster.

---

Definitions:

Inferior Colliculi

Structures in the midbrain that serve as principal midbrain nuclei for the processing of auditory information.

Auditory

Relating to the sense of hearing or the system within the body that is responsible for processing sound.

Visual

Relating to seeing or to the sight, the sense by which the qualities of objects such as color, shape, and size are perceived.

Hippocampus

A part of the brain that is crucial for learning and memory.