A company uses a Microsoft SQL Server database and its applications connect to that database. The company wants to migrate to an Amazon Aurora PostgreSQL database with minimal changes to application code. Which combination of steps meets these requirements? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Enable Babelfish on Aurora PostgreSQL to run the SQL queries from the applications., Migrate the database schema and data by using the AWS Schema Conversion Tool (AWS SCT) and AWS Database Migration Service (AWS DMS)..
Why this is the answer
The correct options address both schema/data migration and application compatibility. Migrating the database schema and data from SQL Server to Aurora PostgreSQL is best achieved using AWS Schema Conversion Tool (SCT) for schema conversion and AWS Database Migration Service (DMS) for data migration. SCT can convert the SQL Server schema to a PostgreSQL-compatible format, and DMS can then efficiently migrate the data. To minimize application code changes, enabling Babelfish for Aurora PostgreSQL is crucial. Babelfish allows Aurora PostgreSQL to understand commands from applications written for Microsoft SQL Server, including T-SQL, by providing a SQL Server-compatible endpoint and translation layer. Rewriting SQL queries in applications using AWS SCT is incorrect because the goal is minimal application code changes, which Babelfish directly addresses. Using Amazon RDS Proxy is incorrect as it manages connections and connection pooling but does not aid
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed