Examkin

Question

Difficulty: MediumAWS Database Services

A company is designing a new e-commerce application and must choose the correct database services for two distinct workloads. The first workload requires storing product catalog metadata with highly dynamic attributes, needing sub-millisecond response times for lookups. The second workload requires storing customer orders with transactional consistency (ACID compliance) and relational database schemas to support complex table joins.

Which of the following database services should the cloud practitioner recommend to meet these requirements? (Select TWO.)

  1. Amazon DynamoDB to store the dynamic product catalog metadataAnswer
  2. Amazon RDS to manage customer order transactions with relational consistencyAnswer
  3. C
    Amazon Redshift to store customer order transactions requiring real-time relational joins
  4. D
    Amazon DynamoDB to store customer order transactions that require complex relational joins
  5. E
    Amazon Aurora with customer-managed operating system updates to host the product catalog

Answer

The correct answers are the option proposing Amazon DynamoDB for storing dynamic product catalog metadata and the option proposing Amazon RDS for managing customer order transactions.
Amazon DynamoDB is a NoSQL key-value and document database that provides single-digit millisecond performance at any scale, making it a perfect fit for a dynamic product catalog. Amazon RDS is a managed relational database service that provides transactional consistency (ACID compliance) and supports complex table joins, making it ideal for order transaction workloads.

Step-by-Step Solution

1
Identify the database requirements for the first workload.
The product catalog needs highly dynamic attributes and sub-millisecond response times.
This points to a NoSQL database with flexible schema and extremely low latency, such as Amazon DynamoDB.
2
Identify the database requirements for the second workload.
Customer order transactions need transactional consistency (ACID compliance) and relational schemas to support complex table joins.
This points to a relational database service (OLTP), such as Amazon RDS or Amazon Aurora.
3
Evaluate the options to select the correct services and eliminate incorrect configurations.
Select the DynamoDB option for the catalog and the RDS option for the transactional orders, while rejecting options that misapply NoSQL/OLAP databases or mischaracterize the Shared Responsibility Model for managed databases.
To choose the two correct service configurations that match the requirements.

Key Concept

Selecting appropriate AWS database services based on relational (RDS/Aurora) vs. non-relational (DynamoDB) characteristics, analytical vs. transactional needs (Redshift vs. RDS), and managed service responsibilities.
Estimated Time:1m 30s
Rate this question

Topics

AWS Database Services

More questions from this topic