Domain 4.4: Modernization Requirements — AWS SAP-C02 Practice Question 75

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

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

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.

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?

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam