CLF-C02 Question 187
Single answerYour company is building a new web application that requires a relational database. The team wants to minimize the operational overhead of managing the database, such as backups, patching, and scaling, while ensuring high availability and security. Which AWS service would be the most suitable for this scenario?
- A
Amazon RDS (Relational Database Service)
- B
Amazon EC2 with a self-managed database installed
- C
Amazon Aurora
- D
Amazon DynamoDB
Show answer and explanation
Correct answer: A
Explanation
Amazon RDS is the most suitable choice for this scenario because it is a managed database service designed to reduce operational overhead by automating tasks like backups, patching, and scaling. It also ensures high availability and security, which aligns with the application's requirements. While Amazon Aurora is another managed relational database service, the scenario does not specify a need for its advanced features, making RDS a simpler and more cost-effective choice. Self-managed solutions on Amazon EC2 would increase operational burden, and DynamoDB is not suitable as it is a NoSQL database.
- A. Correct.
Amazon RDS is a managed database service that handles backups, patching, scaling, and high availability, making it an ideal choice for minimizing operational overhead while using a relational database.
- B. Incorrect.
Using Amazon EC2 with a self-managed database provides full control but requires significant operational management, such as manually handling backups, patching, scaling, and ensuring high availability. This option does not align with the requirement to minimize operational overhead.
- C. Incorrect.
Amazon Aurora is a managed database service that offers high performance and availability but is a specialized version of RDS. While it could meet the requirements, the question does not indicate a need for Aurora's advanced features, making Amazon RDS a more straightforward option.
- D. Incorrect.
Amazon DynamoDB is a fully managed NoSQL database service. Since the scenario specifies the need for a relational database, DynamoDB is not suitable.