Examkin

Question

Difficulty: MediumAWS Database Services

A company is migrating a legacy retail web application to AWS. The application uses a traditional relational database that requires complex SQL transactional queries and table joins. The company wants a fully managed solution that reduces administrative tasks such as hardware provisioning, database setup, patching, and backups, while separating the database tier from the application tier to ensure high availability. Which database solution should the company choose?

  1. Amazon RDSAnswer
  2. B
    Amazon DynamoDB
  3. C
    A self-managed database hosted on a single Amazon EC2 instance
  4. D
    A single Amazon EC2 instance running both the database engine and the web application server

Answer

Amazon RDS
Amazon RDS is the correct choice because it is a managed relational database service that supports SQL queries and table joins while automating database administration tasks such as backups, software patching, and hardware scaling.

Step-by-Step Solution

1
Analyze the application's database requirements
The application requires a relational database that supports complex SQL queries and table joins.
This rules out non-relational database services such as key-value stores.
2
Evaluate the management and operational overhead requirements
The company wants a fully managed service to reduce administrative tasks like patching and backups.
This rules out self-managed options like hosting database engines directly on Amazon EC2 instances.
3
Select the appropriate managed AWS database service
Amazon RDS provides a fully managed relational database platform that automates provisioning, patching, and backups while separating the database from the application tier.
It matches both the relational nature of the workload and the requirement for reduced administrative overhead.

Key Concept

AWS managed relational database service selection versus self-managed or NoSQL alternatives.
Estimated Time:1m 30s
Rate this question

Topics

AWS Database Services

More questions from this topic