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:

Integrated Marketing Communications

A strategic approach to marketing that combines various communication tools and channels to provide a comprehensive message about a product or brand.

Impressions

A measurement used in digital marketing to count the number of times an advertisement or content is displayed, regardless of whether it was clicked or not.

Return On Investment

A measure used to evaluate the efficiency or profitability of an investment, calculated by dividing the return by the cost of the investment.

Advertising Value Equivalency

Advertising Value Equivalency (AVE) is a metric used in public relations to measure the benefit to a client from media coverage by comparing it to the equivalent cost if the space or time were bought as advertising.