CLF-C02 Question 191
Single answerA company is planning to migrate their on-premises relational database to AWS. They require a managed database service that supports SQL, offers high availability, and can automatically replicate data across multiple Availability Zones. Which of the following AWS services should the company choose?
- A
Amazon RDS
- B
Amazon DynamoDB
- C
Amazon Aurora
- D
Amazon Redshift
Show answer and explanation
Correct answer: C
Explanation
Amazon Aurora is the best choice for this scenario because it is a fully managed relational database service that supports SQL and is designed for high availability and performance. Aurora automatically replicates data across multiple Availability Zones, ensuring fault tolerance and durability, which aligns with the company's requirements.
- A. Incorrect.
Amazon RDS is a managed service for relational databases, but it does not offer automatic multi-AZ replication by default unless explicitly configured. It is not as highly optimized for performance and scalability as Amazon Aurora.
- B. Incorrect.
Amazon DynamoDB is a NoSQL database service and does not support relational database workloads or SQL queries. This makes it unsuitable for the company's needs.
- C. Correct.
Amazon Aurora is a relational database service designed for high availability and performance. It supports SQL, automatically replicates data across multiple Availability Zones, and is ideal for this scenario.
- D. Incorrect.
Amazon Redshift is a data warehousing service optimized for analytics and data processing, not for transactional relational database workloads. It is not suitable for this use case.