Question

Difficulty: EasyAWS Database Services

A medical clinic is launching a new patient portal. The application requires a relational database to store patient appointments and dental records using standard SQL. To minimize administrative work, the clinic wants AWS to handle routine tasks such as database engine installation, operating system patching, and hardware maintenance. Which AWS service should the clinic select to meet these requirements?

  1. Amazon RDSAnswer
  2. B
    Amazon DynamoDB
  3. C
    Amazon Redshift
  4. D
    Amazon EBS

Answer

Amazon RDS
Amazon RDS is a fully managed service that supports relational database engines. AWS automatically handles physical infrastructure, database engine installation, operating system patching, and backups, which fulfills the clinic's requirement to minimize database administrative tasks.

Step-by-Step Solution

1
Analyze database requirements
The application requires a relational database and standard SQL.
This rules out non-relational database services.
2
Determine management level requirements
The customer wants AWS to handle database installation, operating system patching, and hardware maintenance.
This requires a managed database service rather than a self-managed hosting option.
3
Select the correct managed relational service
Amazon RDS satisfies both relational SQL requirements and managed administrative operations.
It offers a fully managed platform for standard SQL database engines.

Key Concept

AWS Managed Relational Databases (Amazon RDS)
Estimated Time:45s
Rate this question