Examkin

Question

Difficulty: MediumAWS Database Services

A company is planning to migrate its on-premises relational database to AWS. The database administration team wants to maintain the existing relational schema and SQL query compatibility, while offloading routine database management tasks such as software patching, database backups, and hardware scaling to AWS. Which AWS database service should the company select to meet these requirements?

  1. A
    Amazon ElastiCache
  2. B
    Amazon DynamoDB
  3. Amazon RDSAnswer
  4. D
    Amazon Redshift

Answer

Amazon RDS
Amazon RDS is a fully managed relational database service that allows companies to run popular relational engines (like Oracle, PostgreSQL, and MySQL) while AWS handles infrastructure patching, database engine updates, backups, and scale configuration.

Step-by-Step Solution

1
Determine the required database model based on the business constraints.
The database must support relational schemas and SQL query compatibility.
This rules out non-relational databases and in-memory caches.
2
Assess the operational requirements and database type.
The workload is transactional, and administrative tasks like software patching and backups must be managed by AWS.
This rules out analytical data warehouses and points to Amazon RDS, which is a fully managed relational database service.

Key Concept

Relational Database Migration to Managed AWS Services
Estimated Time:1m 0s
Rate this question

Topics

AWS Database Services

More questions from this topic