Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

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 Hide 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

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
KennethNg923
5 months, 1 week 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 1 times
...
Scheldon
5 months, 3 weeks 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 1 times
...
pranavsharma1604
6 months, 1 week ago
Selected Answer: BC
https://aws.amazon.com/rds/aurora/babelfish/
upvoted 3 times
...
sandordini
6 months, 3 weeks 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 4 times
pranavsharma1604
6 months, 1 week ago
https://aws.amazon.com/rds/aurora/babelfish/
upvoted 1 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel