A company is migrating a legacy application to AWS. The application requires a relational database. The company wants to minimize operational overhead and licensing costs. The database currently uses Microsoft SQL Server, but the schema and queries are simple and do not use any proprietary SQL Server features. The application code can be easily updated to use a different database driver. Which combination of actions represents the MOST cost-effective modernization strategy? (Select TWO)

Answer options:

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.

Migrate the database to Amazon RDS for SQL Server using native backup and restore.

Migrate the database to Amazon DynamoDB using AWS DMS.

Use AWS Application Migration Service (MGN) to lift and shift the SQL Server to an EC2 instance.

Deploy Amazon ElastiCache to cache SQL Server queries to reduce the required license tier.

How to approach this question

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

Full Answer

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.

Question 73 All questions Question 75

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

75 questions · hints · full answers · grading

More questions from this exam

Q01A global enterprise is redesigning its AWS network architecture across 50 AWS accounts and 3 AWS ...Hard Q02A company uses AWS Organizations to manage multiple accounts. The security team mandates that no ...Medium Q03A financial institution requires a disaster recovery strategy for its critical trading applicatio...Hard Q04An enterprise is setting up a new multi-account AWS environment using AWS Control Tower. They nee...Medium Q05A company has a complex AWS environment with hundreds of linked accounts under AWS Organizations....Hard

View all 75 questions →