Exam AWS Certified Cloud Practitioner topic 1 question 375 discussion

Option A is correct, with option B user has to change querys refering Aurora Database Endpoint for each query

The correct answer is A. Amazon RDS for PostgreSQL. Amazon RDS for PostgreSQL is a fully managed database service that makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. It is designed to be compatible with existing PostgreSQL applications, so you can migrate your database to the cloud without changing your queries. Amazon RDS for PostgreSQL can also automatically scale the underlying hardware resources based on the workload, which can help maximize query performance. Amazon Aurora PostgreSQL is also a fully managed database service, but it is designed to be compatible with PostgreSQL and to offer improved performance and scalability. However, it is not a drop-in replacement for PostgreSQL, so you may need to modify your queries to take advantage of its features.

Amazon RDS for PostgreSQL is a fully managed service for PostgreSQL, enabling companies to migrate their existing PostgreSQL databases to the cloud without modifying their applications. It supports standard PostgreSQL queries, ensuring that applications require no modifications and can continue to use their existing queries. RDS for PostgreSQL also optimizes query performance with features such as scalable storage, automatic backups and resource management.

Aurora claims over 3x the performance of Postgres on RDS

Aurora PostgreSQL is a drop-in replacement for PostgreSQL, so no code change is required and its also 3 times faster.

Option A is correct because the queries for the database do not have to change after the migration.

A & B are both valid answers. Both require the same amount or method to migrate. https://aws.amazon.com/blogs/database/best-practices-for-migrating-postgresql-databases-to-amazon-rds-and-amazon-aurora/

B: Aurora PostgreSQL If the company doesn’t want to change the queries that access the database, both Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL would work, as they both support standard PostgreSQL queries. However, if maximizing query performance is a priority, Amazon Aurora PostgreSQL might be the better choice. It’s designed to be compatible with PostgreSQL, so the company can use existing PostgreSQL queries without needing to change them. Plus, Aurora PostgreSQL is often faster than standard PostgreSQL, especially for transaction processing.

B aurora

To migrate a standard PostgreSQL database to the AWS Cloud without changing the queries and maximize query performance, you should consider using: B. Amazon Aurora PostgreSQL Amazon Aurora is a fully managed relational database service that is compatible with both MySQL and PostgreSQL

Correct answer is B = "When you want to achieve the best performance without changing existing queries while moving the current PostgreSQL database to AWS Cloud, considering the scenario you have provided, the best option will be B. Amazon Aurora PostgreSQL."

Amazon RDS for PostgreSQL

Option A

answer is from:https://www.amazonaws.cn/en/rds/aurora/postgresql-features/ Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. The PostgreSQL-compatible edition of Aurora delivers up to 3X the throughput of standard PostgreSQL running on the same hardware, enabling existing PostgreSQL applications and tools to run without requiring modification. The combination of PostgreSQL compatibility with Aurora enterprise database capabilities provides an ideal target for commercial database migrations.

https://aws.amazon.com/rds/aurora/features/ Amazon Aurora is a relational database service that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Aurora is fully compatible with MySQL and PostgreSQL, allowing existing applications and tools to run without requiring modification.

B. Amazon Aurora PostgreSQL https://aws.amazon.com/rds/aurora/features/#Migration_Support "Aurora is fully compatible with MySQL and PostgreSQL, allowing existing applications and tools to run without requiring modification." "Testing on standard benchmarks such as SysBench has shown an increase in throughput of up to 5x over stock MySQL and 3x over stock PostgreSQL on similar hardware. Aurora uses a variety of software and hardware techniques to ensure the database engine is able to fully use available compute, memory, and networking. I/O operations use distributed systems techniques, such as quorums to improve performance consistency."

Aurora PostgreSQL > 3 time faster (RDS PostgreSQL) so for best performance Aurora should be the choice. Most cost effective will be RDS