Examkin

Question

Difficulty: MediumHigh-Performing Database Solutions

A content management company is migrating its application to AWS. The application has two distinct workloads:

1. A transaction-heavy user management system that requires strict ACID compliance and relational integrity, with a read-to-write ratio of 10:110:1. The system must survive a database instance failure with minimal recovery time.
2. A high-volume event logging system that records user clicks. This log has highly unpredictable and spiky write patterns, but queries are simple key-value lookups.

Which configuration represents the most high-performing and scalable database solution?

  1. Deploy an Amazon Aurora Multi-AZ DB cluster for the user management system and use Aurora Read Replicas to offload read traffic. Store the event logging data in an Amazon DynamoDB table configured with On-Demand capacity mode and a partition key of event_uuid.Answer
  2. B
    Deploy a single Amazon RDS PostgreSQL instance for user management, using an RDS Read Replica as the primary failover target to handle automatic disaster recovery. Store the event logging data in an Amazon DynamoDB table configured with On-Demand capacity mode and a partition key of event_uuid.
  3. C
    Deploy an Amazon Aurora Multi-AZ DB cluster for the user management system and use Aurora Read Replicas to offload read traffic. Store the event logging data in an Amazon DynamoDB table configured with On-Demand capacity mode and a partition key of event_date (formatted as YYYY-MM-DD) to group daily event logs.
  4. D
    Deploy an Amazon Aurora Multi-AZ DB cluster for the user management system and use Aurora Read Replicas to offload read traffic. Store the event logging data in an Amazon DynamoDB table using Provisioned capacity mode with a static, pre-defined write capacity limit set to match peak event rates, and a partition key of event_uuid.

Answer

Deploy an Amazon Aurora Multi-AZ DB cluster for the user management system and use Aurora Read Replicas to offload read traffic. Store the event logging data in an Amazon DynamoDB table configured with On-Demand capacity mode and a partition key of event_uuid.
The correct configuration utilizes an Amazon Aurora Multi-AZ DB cluster to ensure high availability and relational performance, offloading read traffic to read replicas. For the event logging system, Amazon DynamoDB with a high-cardinality partition key (event_uuid) distributes write operations evenly across partitions. Configuring the table in On-Demand capacity mode accommodates highly unpredictable, spiky write workloads efficiently without throttling or unnecessary idle capacity costs.

Step-by-Step Solution

1
Analyze the requirements for the user management workload.
Identified the need for relational integrity, strict ACID compliance, a read-to-write ratio of 10:110:1, and rapid failover.
Determining the database engine and high-availability configuration.
2
Analyze the requirements for the event logging workload.
Identified the need for key-value lookups and high-volume, highly unpredictable, spiky write patterns.
Selecting the NoSQL database engine and scaling/partitioning strategy.
3
Compare database solutions and configurations for both workloads.
Amazon Aurora Multi-AZ with Read Replicas fits user management. Amazon DynamoDB with a high-cardinality partition key (event_uuid) and On-Demand capacity fits the logging workload.
Selecting the configuration that maximizes performance and availability while avoiding bottlenecks and over-provisioning.

Key Concept

High-performing database design involves selecting the correct database engine (relational vs. NoSQL) based on access patterns, configuring appropriate high availability (Multi-AZ vs. replicas), and designing proper partition keys and capacity modes in DynamoDB to handle write patterns.
Rate this question

Topics

High-Performing Database Solutions

More questions from this topic