AWS Certified Solutions Architect – Associate (SAA-C03) — Question 846

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? (Choose two.)

Answer options

• A. Use the AWS Schema Conversion Tool (AWS SCT) to rewrite the SQL queries in the applications.
• 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).
• D. Use Amazon RDS Proxy to connect the applications to Aurora PostgreSQL.
• E. Use AWS Database Migration Service (AWS DMS) to rewrite the SQL queries in the applications.

Correct answer: B, C

Explanation

Babelfish for Aurora PostgreSQL allows Aurora to understand T-SQL dialect, enabling applications written for SQL Server to run with minimal code changes. To actually migrate the schema and database contents, AWS SCT and AWS DMS are the standard services designed to convert and replicate the data. Neither AWS SCT nor AWS DMS is capable of automatically rewriting SQL queries embedded within application source code, and Amazon RDS Proxy is a database proxy for connection pooling rather than a query translation layer.