AWS Certified Cloud Practitioner — Question 225
A company is running a standard PostgreSQL database on premises. The company is migrating the database to the AWS Cloud and does not want to change the queries that access the database. The company must maximize the query performance.
Which AWS service will meet these requirements?
Answer options
- A. Amazon RDS for PostgreSQL
- B. Amazon Aurora PostgreSQL
- C. Amazon DocumentDB (with MongoDB compatibility)
- D. Amazon DynamoDB
Correct answer: B
Explanation
Amazon Aurora PostgreSQL is designed for high performance and compatibility with PostgreSQL, making it ideal for scenarios where existing queries must remain unchanged. While Amazon RDS for PostgreSQL also supports PostgreSQL, Aurora typically offers better performance and scalability. Amazon DocumentDB and DynamoDB are not suitable as they are not PostgreSQL-based and would require significant changes to the queries.