Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 886 discussion

B: Babelfish for Aurora PostgreSQL is a new capability for Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server. C: Is just obvious: Use Data Migration Tool for the migration, Schema Conversion tool for the Schema conversion.

A - AWS SCT does not directly rewrite SQL queries in the application code. This would require manual updates. B - Babelfish allows Aurora PostgreSQL to understand SQL Server’s native T-SQL language and protocol. C - Convert the schema & migrate the data effectively, good. D - Amazon RDS Proxy improves database scalability and availability (if the question mentions something like having trouble conneting during peek hours or whatnot then RDS Proxy is likely the answer) but does not address the compatibility issues between SQL Server and Aurora PostgreSQL. E - This is not enough. Refer to option C.

DMS + SCT is correct, but " rewrite the SQL queries in the applications." is wrong so A + E are out. Then only left B + C -> DMS + SCT + Babekfish (for SQL Server)

AnswerBC DMS will allow for DATABASE migration and use AWS Schema Conversion Tool (AWS SCT) to create some or all of the target tables, indexes, views, triggers, and so on. https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html To minimalize amount of code which need to me changes we need to use babelfish https://aws.amazon.com/rds/aurora/babelfish/

https://aws.amazon.com/rds/aurora/babelfish/