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

How to approach this question

Identify the strategy that eliminates commercial licensing costs (moving to open-source).

Full Answer

Migrate the database to Amazon Aurora PostgreSQL using the AWS Schema Conversion Tool (SCT) and AWS DMS., Update the application code to use the PostgreSQL JDBC/ODBC drivers.

To minimize licensing costs, the best strategy is to modernize by migrating away from commercial database engines (like Microsoft SQL Server) to open-source engines (like PostgreSQL or MySQL). Amazon Aurora provides commercial-grade performance with open-source compatibility. Because the application queries are simple and the code can be updated, using AWS SCT and DMS to migrate to Aurora PostgreSQL, and updating the application drivers, is the most cost-effective long-term strategy.

Common mistakes

Choosing RDS for SQL Server, which reduces operational overhead but does not eliminate licensing costs.

How to approach this question

Full Answer

Common mistakes

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

More questions from this exam