Examkin

Question

Difficulty: EasyAWS Database Services

A company is migrating a traditional web application to the AWS Cloud. The application's backend database requires support for structured data, complex SQL queries, and transactional joins. Additionally, the company wants to minimize administrative overhead by having AWS manage database patching, software installations, and backups. Which AWS service should the company use to meet these requirements?

  1. Amazon Relational Database Service (Amazon RDS)Answer
  2. B
    Amazon DynamoDB
  3. C
    Amazon ElastiCache
  4. D
    Amazon Simple Storage Service (Amazon S3)

Answer

Amazon Relational Database Service (Amazon RDS) is the correct service because it provides a fully managed relational database that supports SQL queries and joins, while offloading administrative tasks like patching and backups to AWS.
Amazon Relational Database Service (Amazon RDS) is the correct service because it is a managed relational database service that supports standard SQL engines (such as PostgreSQL, MySQL, and MariaDB) and handles administrative tasks like hardware provisioning, database setup, patching, and backups.

Step-by-Step Solution

1
Analyze the database type requirement.
The scenario specifies a requirement for a structured database that supports complex SQL queries and transactional joins, which indicates a relational database.
Relational databases are designed for schema enforcement and SQL joins, unlike NoSQL databases or object storage.
2
Analyze the management requirement.
The customer wants to minimize administrative overhead by offloading patching, software installations, and backups to AWS.
A managed database service like Amazon RDS automates these administrative tasks, whereas hosting a database on self-managed infrastructure would require the customer to handle them.
3
Select the matching AWS service.
Amazon RDS meets both the relational database requirement and the managed administration requirement.
RDS is the primary AWS service for managed relational databases.

Key Concept

Identifying the appropriate AWS database service based on business and technical requirements, specifically distinguishing relational (RDS) from non-relational services.
Rate this question

Topics

AWS Database Services

More questions from this topic