Q71 — AWS SAA-C03 Ch.13

Question 71 of 100 | ← Chapter 13

Q971. A company uses a Microsoft SQL Server database. The company's applications are connected to the database. The company wants to migrate to an Amazon Aurora PostgreSQL database with minimal changes to the application code.Which combination of steps will meet these requirements?(Select TWO.)

Correct Answer: B. Enable Babelfish on Aurora PostgreSQL to run the SQL queries from the applications, C. Migrate the database schema and data by using the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS)

Explanation

The correct answers are:B. Enable Babelfish on Aurora PostgreSQL to run the SQL queries from the applications C. Migrate the database schema and data by using the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS)Explanation:A. Use the AWS Schema Conversion Tool (AWS SCT) to rewrite the SQL queries in the applications- This is not the recommended approach, as it requires modifying the application code, which goes against the requirement of minimal changes to the application code.B. Enable Babelfish on Aurora PostgreSQL to run the SQL queries from the applications- Babelfish is a feature of Aurora PostgreSQL that provides compatibility with Microsoft SQL Server, allowing the applications to connect to the Aurora PostgreSQL database with minimal changes.- This meets the requirement of minimal changes to the application code.C. Migrate the database schema and data by using the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS)- This is a valid approach to migrate the database schema and data from Microsoft SQL Server to Aurora PostgreSQL.- This step, combined with the Babelfish feature in step B, provides a complete solution for migrating the database with minimal changes to the application code.D. Use Amazon RDS Proxy to connect the applications to Aurora PostgreSQL- This is also a valid approach, but it is not as essential as the Babelfish feature in step B, which directly addresses the compatibility of the application's SQL queries.E. Use AWS Database Migration Service (AWS DMS) to rewrite the SQL queries in the applications- This is not the recommended approach, as it requires modifying the application code, which goes against the requirement of minimal changes to the application code.In summary, the correct combination of steps is B (Enable Babelfish on Aurora PostgreSQL) and C (Migrate the database schema and data using AWS SCT and AWS DMS), as they both meet the requirement of minimal changes to the application code.