CLF-C02 Question 189
Single answerA company wants to migrate their on-premises relational database to AWS. They need a fully managed service that supports MySQL and PostgreSQL, offers high availability, and provides the ability to replicate data across multiple AWS Regions for disaster recovery. Which of the following services would meet their requirements?
- A
Amazon RDS
- B
Amazon Aurora
- C
Amazon DynamoDB
- D
Amazon Redshift
Show answer and explanation
Correct answer: B
Explanation
Amazon Aurora is the best choice for this scenario because it is a fully managed relational database service that supports MySQL and PostgreSQL. It offers built-in high availability, automatic scaling, and cross-Region replication, which are ideal for disaster recovery. While Amazon RDS supports MySQL and PostgreSQL, it does not natively provide cross-Region replication without additional configuration, making Aurora the more suitable option.
- A. Incorrect.
Amazon RDS is a fully managed relational database service that supports MySQL and PostgreSQL. However, while it supports high availability within a single Region using Multi-AZ deployments, it does not natively provide cross-Region replication without additional configuration.
- B. Correct.
Amazon Aurora is a fully managed relational database service that is compatible with MySQL and PostgreSQL. It offers high availability, performance improvements, and built-in cross-Region replication, making it a suitable choice for disaster recovery.
- C. Incorrect.
Amazon DynamoDB is a NoSQL database service, which is not designed for relational database use cases. It does not support MySQL or PostgreSQL, so it is not suitable for this scenario.
- D. Incorrect.
Amazon Redshift is a fully managed data warehouse service designed for analytical workloads. It is not intended for use as a relational database for transactional applications, and it does not natively support MySQL or PostgreSQL.