Examkin

Question

Difficulty: MediumAWS Database Services

A company plans to migrate its legacy on-premises relational database to AWS. The IT team wants to minimize administrative tasks such as operating system patching, database software patching, and storage provisioning. At the same time, the database administrators still need to manage database schemas and customize database engine parameters. Which AWS service should the company use to meet these requirements?

  1. A
    Amazon EC2
  2. Amazon RDSAnswer
  3. C
    Amazon DynamoDB
  4. D
    AWS Elastic Beanstalk

Answer

Amazon RDS
Amazon Relational Database Service (Amazon RDS) is a fully managed service that offloads administrative tasks such as hardware provisioning, database setup, patching, and backups, while allowing database administrators to retain control over schemas and engine parameter settings.

Step-by-Step Solution

1
Identify the type of source database and administrative requirements.
The source database is relational, and the company wants to minimize infrastructure administration (patching, backups, provisioning) while maintaining control over schemas and database parameters.
This helps filter services based on the relational model and the level of management required.
2
Compare candidate AWS services against the management and relational requirements.
Amazon RDS automates infrastructure management (patching, backups) but allows schema and parameter control. Amazon EC2 requires self-management of patching. Amazon DynamoDB is NoSQL and does not support relational engines. AWS Elastic Beanstalk is a deployment platform.
This determines the optimal service that satisfies all constraints with the least overhead.

Key Concept

Managed relational database services on AWS
Estimated Time:1m 0s
Rate this question

Topics

AWS Database Services

More questions from this topic