DBS-C01 · Question #251
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 spe
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #251. The question stem and answer options stay visible for context.
Question
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?
Options
- AOverride the default uppercase format of Oracle schema by encasing object names in quotation
- BUse AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-
- CUse the AWS Schema Conversion Tool conversion agent to convert the metadata from
- DUse an AWS Glue job that is attached to an AWS Database Migration Service (AWS DMS)
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.