Examkin

Question

Difficulty: MediumAWS Database Services

A logistics company is migrating its traditional web application to AWS. The application relies on a relational database schema that requires complex SQL queries and table joins. To minimize management effort, the company wants AWS to handle database setup, operating system patching, and automated backups, while maintaining standard MySQL compatibility. Which AWS database option meets these requirements?

  1. A
    Amazon DynamoDB
  2. B
    MySQL hosted on an Amazon EC2 instance
  3. Amazon RDS for MySQLAnswer
  4. D
    Amazon Redshift

Answer

Amazon RDS for MySQL
Amazon RDS is a managed service for relational databases that simplifies database administration. It automates setup, operating system patching, and database backups, while providing full compatibility with MySQL, thereby satisfying all of the company's requirements.

Step-by-Step Solution

1
Identify the data structure and querying needs.
The application requires a relational database schema with complex SQL queries and table joins.
This rules out non-relational options like Amazon DynamoDB, which does not support native SQL joins.
2
Determine the management overhead constraints.
The client wants automated backups, OS patching, and managed setup.
This rules out self-managing MySQL on Amazon EC2, where these operational tasks fall under the customer's responsibility.
3
Match the workload type to the appropriate database service.
A web application requires transactional processing (OLTP), not analytical processing (OLAP).
This rules out Amazon Redshift, which is optimized for data warehousing and large-scale analytics rather than high-concurrency transactional web apps.

Key Concept

Selecting the appropriate managed relational database service in AWS to balance relational query capabilities and operational management overhead.
Rate this question

Topics

AWS Database Services

More questions from this topic