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

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03

Question #: 886
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

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.)

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.

Show Suggested Answer

Suggested Answer: BC 🗳️

by sandordini at April 30, 2024, 4:48 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

sandordini

Highly Voted 1 year, 3 months ago

Selected Answer: BC

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.

upvoted 6 times

pranavsharma1604

1 year, 3 months ago

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

upvoted 3 times

...

LeonSauveterre

Most Recent 7 months, 2 weeks ago

Selected Answer: BC

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.

upvoted 2 times

...

KennethNg923

1 year, 2 months ago

Selected Answer: BC

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)

upvoted 2 times

...

Scheldon

1 year, 2 months ago

Selected Answer: BC

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/

upvoted 2 times

...

pranavsharma1604

1 year, 3 months ago

Selected Answer: BC

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

upvoted 4 times

...