CLF-C02 Question 190
Select 2Your company is planning to migrate its on-premises relational database to AWS. The team requires a managed database service that supports MySQL and PostgreSQL, provides automated backups, and can handle high availability with failover support. Which AWS services should the team consider?
- A
Amazon RDS
- B
Amazon DynamoDB
- C
Amazon Aurora
- D
Amazon Redshift
- E
Amazon ElastiCache
Show answer and explanation
Correct answers: A, C
Explanation
Amazon RDS and Amazon Aurora are the correct choices because they are managed relational database services that support MySQL and PostgreSQL. Both services provide features like automated backups, high availability, and failover support, which align with the requirements in the scenario. Other options, like DynamoDB, Redshift, and ElastiCache, do not meet the criteria because they are either non-relational or designed for other use cases (e.g., caching or analytics).
- A. Correct.
Amazon RDS is a managed relational database service that supports multiple database engines, including MySQL and PostgreSQL. It provides automated backups, high availability, and failover support.
- B. Incorrect.
Amazon DynamoDB is a NoSQL database service designed for key-value and document-based use cases. It is not a relational database and does not support MySQL or PostgreSQL.
- C. Correct.
Amazon Aurora is a relational database service compatible with MySQL and PostgreSQL. It offers high performance, high availability, automated backups, and failover support.
- D. Incorrect.
Amazon Redshift is a data warehousing service optimized for analytics over large datasets. It is not designed for transactional relational database use cases.
- E. Incorrect.
Amazon ElastiCache is an in-memory cache service that supports Redis and Memcached. It is not a relational database and is primarily used to improve the performance of database-driven applications.