CLF-C02 Question 188
Single answerYou are building a new application that requires a database. The application team wants minimal operational overhead and automated backups, while your organization needs to focus on scalability and availability. Which database solution should you choose?
- A
Deploy a MySQL database on an Amazon EC2 instance with custom configurations.
- B
Use Amazon RDS to set up a managed MySQL database with automated backups.
- C
Deploy an Amazon DynamoDB table for relational data storage.
- D
Set up a PostgreSQL database on your on-premises server for full control over configurations.
Show answer and explanation
Correct answer: B
Explanation
Amazon RDS is the best option when you need a managed relational database service with minimal operational overhead, automated backups, and scalability. It eliminates the need to manually manage infrastructure and allows you to focus on application development. EC2-hosted databases or on-premises solutions require more manual management, which is not ideal in this scenario. DynamoDB is not suitable for relational data use cases.
- A. Incorrect.
Choosing an EC2-hosted MySQL database requires you to manually manage backups, scaling, and maintenance, which contradicts the application's need for minimal operational overhead.
- B. Correct.
Amazon RDS is a managed database service that provides automatic backups, scaling capabilities, and reduced operational overhead, aligning with the application's requirements.
- C. Incorrect.
Amazon DynamoDB is a NoSQL database designed for key-value and document data models, not relational data, which does not meet the application's needs for a relational database solution.
- D. Incorrect.
Using an on-premises PostgreSQL database would require significant operational overhead and does not leverage AWS managed services, making it unsuitable for this scenario.