
Answer-first summary for fast verification
Answer: Using the AWS RDS service
## Explanation For a **self-managed database** in AWS, the ideal solution is **Amazon RDS (Relational Database Service)**, not DynamoDB. ### Key Differences: **Amazon RDS:** - **Managed relational database service** that supports various database engines (MySQL, PostgreSQL, Oracle, SQL Server, etc.) - **Self-managed** in the sense that you still need to handle database administration tasks like schema design, query optimization, and backups - AWS manages the underlying infrastructure, patching, and scaling - You have full control over the database instance **Amazon DynamoDB:** - **Fully managed NoSQL database service** - **Serverless** - AWS handles all administrative tasks automatically - Limited control over the database management aspects - Not suitable for traditional relational database workloads ### Why RDS is the Correct Choice: 1. **Self-managed requirement**: RDS provides the balance where AWS manages infrastructure while you manage the database itself 2. **Traditional database hosting**: RDS is designed for hosting traditional relational databases 3. **Administrative control**: You maintain control over database configuration, user management, and performance tuning For a truly self-managed database where you want complete control over the operating system and database software, you would use **Amazon EC2** instead, but between the given options, RDS is the better choice for hosting a self-managed database.
Author: Ritesh Yadav
Ultimate access to all questions.
No comments yet.