DBS-C01 · Question #251
DBS-C01 Question #251: Real Exam Question with Answer & Explanation
The correct answer is B: Use AWS Database Migration Service (AWS DMS) mapping rules with rule-action as convert-. https://aws.amazon.com/premiumsupport/knowledge-center/dms-mapping-oracle-postgresql/
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)
Explanation
https://aws.amazon.com/premiumsupport/knowledge-center/dms-mapping-oracle-postgresql/
Topics
Community Discussion
No community discussion yet for this question.