Answer-first summary for fast verification
Answer: Amazon Aurora PostgreSQL, a managed service compatible with PostgreSQL, providing enhanced performance and scalability, but may require query modifications.
The correct answer is B, Amazon Aurora PostgreSQL. Amazon Aurora is a fully managed relational database service that is compatible with both MySQL and PostgreSQL. It is designed to provide high performance and scalability while being fully compatible with existing PostgreSQL applications and tools, meaning no changes are required to the queries. This makes it an ideal choice for migrating a standard PostgreSQL database to the AWS Cloud without altering the queries and with the goal of maximizing query performance. Amazon RDS for PostgreSQL, while also a fully managed service, may not offer the same level of performance as Aurora for this specific use case.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which AWS service is suitable for migrating an on-premises PostgreSQL database to the cloud without altering access queries and ensuring maximum query performance?
A
Amazon RDS for PostgreSQL, offering compatibility with existing PostgreSQL apps and automatic hardware resource scaling based on workload.
B
Amazon Aurora PostgreSQL, a managed service compatible with PostgreSQL, providing enhanced performance and scalability, but may require query modifications.
C
Amazon DocumentDB, a MongoDB-compatible document database, offering fast performance at scale but not compatible with PostgreSQL.
D
Amazon DynamoDB, a NoSQL database service with fast, scalable performance, incompatible with PostgreSQL and requiring a different data model and query language.
No comments yet.