A company is migrating a legacy application that requires a relational database. The application uses complex SQL queries and stored procedures. The company wants to minimize database licensing costs and operational overhead. Which migration strategy is BEST?

Answer options:

Rehost the database on an EC2 instance.

Migrate to Amazon DynamoDB.

Migrate to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).

Migrate to Amazon RDS for Oracle.

How to approach this question

Balance relational requirements with cost and overhead reduction.

Full Answer

C.Migrate to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS).✓ Correct

Amazon Aurora provides the performance of commercial databases (like Oracle/SQL Server) with the cost-effectiveness of open-source databases (PostgreSQL/MySQL). SCT and DMS are the standard tools for this modernization.

Common mistakes

Choosing DynamoDB for an application that requires complex SQL.

Question 74 All questions

Practice the full AWS Solutions Architect Professional SAP-C02 Practice Exam 2

75 questions · hints · full answers · grading

More questions from this exam

Q01A company is setting up a multi-account AWS environment using AWS Organizations. They need to ens...Easy Q02An enterprise needs to connect its on-premises data center to AWS. They require a dedicated, priv...Easy Q03A company wants to share a single AWS Transit Gateway across multiple AWS accounts within their A...Easy Q04An architect needs to design a highly available database architecture that spans multiple AWS Reg...Easy Q05A global financial institution is migrating its core banking application to AWS. The application ...Medium

View all 75 questions →