Examkin

Question

Difficulty: MediumAWS Database Services

A medical billing company is planning to migrate its legacy on-premises relational database to AWS. The company requires a database solution that is fully managed by AWS to handle database patching, operating system maintenance, and automated backups, while still allowing them to run complex SQL transactions with schema enforcement. Which AWS service is best suited to meet these requirements?

  1. A
    Amazon DynamoDB
  2. B
    Amazon Redshift
  3. Amazon RDSAnswer
  4. D
    Amazon Elastic Block Store (Amazon EBS)

Answer

Amazon RDS
Amazon Relational Database Service (Amazon RDS) is a fully managed service that supports relational database engines (such as PostgreSQL, MySQL, and Oracle). It automatically handles administrative tasks like software patching, OS maintenance, and backups, while allowing the customer to manage schemas and run transactional SQL queries.

Step-by-Step Solution

1
Analyze the workload requirements
The workload is relational, requiring SQL transactional capabilities and schema enforcement.
This rules out non-relational (NoSQL) database engines.
2
Analyze the management requirements
The customer wants automated OS patching, backups, and maintenance to be fully managed by AWS.
This rules out self-managed solutions on block storage or EC2.
3
Select the matching AWS database service
Amazon RDS matches both relational SQL capability and fully managed operational support.
Amazon RDS is specifically built to offload administrative tasks while supporting relational SQL database engines.

Key Concept

Distinguishing between managed relational databases and other storage or NoSQL services under the AWS Shared Responsibility Model.
Estimated Time:1m 30s
Rate this question

Topics

AWS Database Services

More questions from this topic