
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
A company is migrating a relational database server to the AWS Cloud. The company wants to minimize administrative overhead of database maintenance tasks.
Which AWS service will meet these requirements?
A
Amazon DynamoDB
B
Amazon EC2
C
Amazon Redshift
D
Amazon RDS
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
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.