AWS Certified Database – Specialty — Question 356

A company hosts a 2 TB Oracle database in its on-premises data center. A database specialist is migrating the database from on premises to an Amazon Aurora
PostgreSQL database on AWS.
The database specialist identifies a problem that relates to compatibility Oracle stores metadata in its data dictionary in uppercase, but PostgreSQL stores the metadata in lowercase. The database specialist must resolve this problem to complete the migration.
What is the MOST operationally efficient solution that meets these requirements?

Answer options

• A. Override the default uppercase format of Oracle schema by encasing object names in quotation marks during creation.
• B. Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-lowercase.
• C. Use the AWS Schema Conversion Tool conversion agent to convert the metadata from uppercase to lowercase.
• D. Use an AWS Glue job that is attached to an AWS Database Migration Service (AWS DMS) replication task to convert the metadata from uppercase to lowercase.

Correct answer: B

Explanation

Using AWS Database Migration Service (AWS DMS) mapping rules with the 'convert-lowercase' rule-action is the most operationally efficient solution because it natively handles the case conversion during replication without extra infrastructure. Modifying the source schema manually or using AWS Glue adds unnecessary complexity and overhead. The AWS Schema Conversion Tool conversion agent is not designed for this specific metadata transformation during active replication.