A company is migrating a large on-prem Oracle database (withstored procedures) to AWS. The solution must usemanaged services, behighly available, and enable a fast migration with minimal downtime. Which solution meets these requirements?

Question

Accepted Answer

D. Use DMS to migrate to Amazon Aurora PostgreSQL. Use AWS SCT to convert stored AWS DMS enables fast, minimal-downtime migration, Amazon Aurora PostgreSQL provides a highly available and managed database service, and AWS SCT is specifically designed to convert Oracle schemas and stored procedures to PostgreSQL, meeting all requirements.

Answer

A. Use AWS DMS to replicate data to RDS for Oracle. Store database files in S3. Storing primary database files in S3 is not how Amazon RDS for Oracle operates; RDS manages its own underlying storage, making this part of the solution incorrect for live transactional use.

Answer

B. Use backup and restore into EC2-hosted Oracle cluster. An EC2-hosted Oracle cluster is not a managed database service, contradicting the requirement for using managed services.

Answer

C. Use DMS to move data to DynamoDB. Recreate stored procedures in Lambda. Migrating a relational Oracle database to a NoSQL database like DynamoDB is a significant re-architecture that would involve extensive application changes beyond a fast, minimal-downtime database migration.

A company is migrating a large on-prem Oracle database (withstored procedures) to AWS. The solution must usemanaged services, behighly available, and enable a fast migration with minimal downtime. Whi

Question

Options

How the community answered

Why each option

Community Discussion