SAP-C02 Practice Question 79: DMS Schema Conversion Assessment

AWS Certified Solutions Architect – Professional (SAP-C02) · Test 8 · question 9 of 10

Migration and Modernizationeasy

A company plans to move a large Oracle database, with thousands of PL/SQL packages, to Amazon Aurora PostgreSQL. Before approving the project, management wants an estimate of how much of the schema and code will convert automatically and how much will need manual work. No data should be migrated yet.

What should the solutions architect do FIRST?

Show answer and explanation

Answer:

A. Create an AWS DMS Schema Conversion migration project and generate a conversion assessment report

DMS Schema Conversion converts source database schemas *"to a format compatible with your target database on Aurora, Amazon RDS, or Amazon Redshift,"* and Oracle to Aurora PostgreSQL is a supported path. It *"reads your source metadata"*, and you *"can run an assessment to see what converts automatically and what needs manual work."* AWS describes the report as a way to *"estimate the effort of a migration before you commit to it"* (option A). It works on schema and code objects, so no data has to be moved.

- B is wrong because a full-load task moves data, not code, and failures would only show table copy errors, not how much PL/SQL can be converted. - C is wrong because data validation compares data between source and target after migration. It says nothing about schema conversion effort. - D is wrong because Babelfish adds SQL Server compatibility to Aurora PostgreSQL. It does not run Oracle PL/SQL.

Reference: Converting database schemas using DMS Schema Conversion

Practice Test 8 ›

Study guides for SAP-C02

Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.

SAP-C02 vs SAP-C03, the Solutions Architect Professional updateWhat changes when AWS replaces SAP-C02 with SAP-C03, the key dates, who should still sit SAP-C02, and how to study through the switch without wasted work.

AWS disaster recovery strategies, RTO and RPOBackup and restore, pilot light, warm standby and active/active on AWS, how RTO and RPO pick between them, and the services each strategy uses.

IAM users, roles and policies on AWSHow IAM users, roles, identity-based and resource-based policies, cross-account access, SCPs and permissions boundaries fit together for AWS exams.

SQS vs SNS vs EventBridge on AWSWhen to use an SQS queue, an SNS topic or an EventBridge bus, plus fan-out, FIFO ordering, visibility timeouts and dead-letter queues for AWS exams.

VPC endpoints vs NAT gateways on AWSWhen to use gateway endpoints, interface endpoints (PrivateLink) or a NAT gateway for private subnets, and the cost and security trade-offs exams test.