Explanation
Amazon RDS (Relational Database Service) is the correct choice because:
- Managed Service: Amazon RDS is a fully managed relational database service that handles routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair
- Minimizes Administrative Overhead: With RDS, AWS manages the underlying infrastructure, database engine maintenance, and automated backups, allowing the company to focus on their applications rather than database administration
- Relational Database Support: RDS supports popular relational database engines including MySQL, PostgreSQL, Oracle, SQL Server, and MariaDB
Why not the other options:
- Amazon DynamoDB: This is a NoSQL database service, not a relational database service
- Amazon EC2: This requires the company to manage the entire database stack including the operating system, database software, and all maintenance tasks
- Amazon Redshift: This is a data warehousing service optimized for analytics, not for general-purpose relational database workloads
Amazon RDS specifically addresses the requirement to minimize administrative overhead while maintaining relational database functionality.