CLF-C02 Question 186
Single answerYour company is planning to deploy a new application that requires a relational database. The application team needs to focus on development rather than database maintenance, and they require features like automated backups, multi-AZ availability, and scalability with minimal administrative effort. Which database solution is most appropriate for this scenario?
- A
Host the database on Amazon EC2 and manage it manually.
- B
Use Amazon RDS (Relational Database Service) to manage the database.
- C
Deploy a self-hosted database on Amazon EC2 with third-party automation tools.
- D
Use Amazon DynamoDB as the database solution.
Show answer and explanation
Correct answer: B
Explanation
Amazon RDS is the best choice for this scenario because it is a fully managed relational database service that provides the required features such as automated backups, multi-AZ availability, and scalability while minimizing administrative effort. This allows the application team to focus on development rather than database maintenance, which aligns with their needs.
- A. Incorrect.
Hosting a database on Amazon EC2 requires manual management of backups, scaling, patching, and high availability, which does not align with the application team's need to focus on development and minimize administrative effort.
- B. Correct.
Amazon RDS is a fully managed database service that provides automated backups, multi-AZ availability, scalability, and reduces administrative overhead, making it the most suitable option for the described requirements.
- C. Incorrect.
Deploying a self-hosted database on EC2 with third-party tools may automate some tasks, but it still requires significant manual setup and maintenance compared to a managed service like Amazon RDS.
- D. Incorrect.
Amazon DynamoDB is a NoSQL database service, and the scenario specifically requires a relational database. Hence, DynamoDB is not a suitable choice.