Examkin

Question

Difficulty: EasyAWS Database Services

An educational institution is building a portal to store student enrollment details and class schedules. The administration requires a database solution that organizes data in tables with predefined schemas and supports standard SQL queries. They want to minimize administrative overhead by choosing a fully managed service that handles software patching and automatic backups. Which AWS service is best suited 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)
Amazon Relational Database Service (Amazon RDS) is the correct choice because it is a fully managed service that allows customers to run relational databases (which support predefined schemas and standard SQL queries) while offloading tasks like patching, backups, and scaling to AWS.

Step-by-Step Solution

1
Analyze the application requirements for structured data, predefined schemas, and standard SQL queries.
Determine that a relational database model is needed.
Relational databases use tables, rows, columns, and SQL to organize and query structured data.
2
Evaluate the administrative requirement to minimize overhead through automated patching and backups.
Identify that a fully managed AWS database service is required.
Managed database services offload routine administrative tasks like software patching and database backups from the customer.
3
Select the AWS service that provides a managed relational database environment.
Determine that Amazon RDS matches all criteria.
Amazon RDS is a fully managed service designed specifically for hosting relational databases using standard SQL engines.

Key Concept

AWS Managed Relational Database Services
Estimated Time:45s
Rate this question

Topics

AWS Database Services

More questions from this topic