A company runs an application on Microsoft SQL Server databases in an on-premises data center. The company wants to migrate to AWS and optimize costs for its infrastructure on AWS.
Which solution will meet these requirements?
A.
Migrate the databases to Amazon EC2 instances that use SQL Server Amazon Machine Images (AMIs) provided by AWS.
B.
Migrate to Amazon Aurora PostgreSQL by using Babelfish for Aurora PostgreSQL.
C.
Migrate the databases to a PostgreSQL database that runs on Amazon EC2 instances.
D.
Migrate the databases to Amazon RDS for Microsoft SQL Server.
Amazon Aurora PostgreSQL with Babelfish allows SQL Server applications to run directly on Aurora PostgreSQL with minimal code changes. Babelfish adds a SQL Server-compatible endpoint, significantly lowering costs compared to running licensed SQL Server instances on RDS or EC2.
AWS Documentation Extract:
“Babelfish for Aurora PostgreSQL enables Aurora to understand T-SQL and SQL Server wire protocol, allowing you to run SQL Server applications on Amazon Aurora PostgreSQL with lower costs.”
(Source: Babelfish for Aurora PostgreSQL documentation)
A, D: SQL Server on EC2 or RDS incurs high Microsoft licensing costs.
C: Plain PostgreSQL would require more code refactoring than Babelfish.
[Reference: AWS Certified Solutions Architect – Official Study Guide, Babelfish and Cost Optimization., , ]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit