Examkin

Question

Difficulty: MediumHigh-Performing Database Solutions

A software company is building a collaborative online drafting application with users distributed across North America and Europe. The architecture requires a relational database to store document metadata and version history, supporting complex queries and auto-scaling read performance in both regions. Additionally, the application requires a data store to manage real-time collaborator session state and presence details with sub-millisecond response times. Which combination of database configurations should a solutions architect recommend to meet these requirements? (Select TWO.)

  1. Amazon Aurora Global Database to store relational document metadata, using read replicas in the secondary region to scale read performance.Answer
  2. Amazon ElastiCache for Redis to manage real-time collaborator session state and presence details with sub-millisecond latencies.Answer
  3. C
    Amazon RDS for PostgreSQL with cross-region read replicas configured as the primary target for automatic failover.
  4. D
    Amazon DynamoDB with partition keys designed using monotonically increasing timestamps to optimize data ingestion for document version history.
  5. E
    Amazon DynamoDB configured in provisioned capacity mode with fixed write limits to handle unpredictable spikes in collaborator presence traffic.

Answer

The solutions architect should choose Amazon Aurora Global Database to store relational document metadata with read replicas in the secondary region, and Amazon ElastiCache for Redis to manage real-time collaborator session state with sub-millisecond latencies.
To support a relational, globally distributed database with complex query capabilities and read scaling, Amazon Aurora Global Database is the ideal choice as it provides low-latency local reads in secondary regions. For real-time user session state requiring sub-millisecond latencies, an in-memory solution like Amazon ElastiCache for Redis is optimized for this performance envelope.

Step-by-Step Solution

1
Analyze the requirement for document metadata and version history.
The database must be relational, support complex queries, and scale reads globally (North America and Europe) with low latency.
This points to Amazon Aurora Global Database, which supports cross-region read replicas and automated scaling.
2
Analyze the requirement for real-time collaborator session state.
This requires a sub-millisecond latency data store to track active users and their presence.
Amazon ElastiCache for Redis is an in-memory key-value store that provides sub-millisecond latencies suitable for real-time state tracking.
3
Evaluate and eliminate incorrect database configurations.
Eliminated options using RDS replicas for automatic failover, DynamoDB with monotonic partition keys, and DynamoDB with provisioned capacity for spiky workloads.
These options violate design practices, leading to failover misconceptions, partition key bottlenecks, or performance throttling under spiky loads.

Key Concept

Selecting and configuring high-performing databases based on latency, query patterns, and global read scalability requirements.
Estimated Time:2m 0s
Rate this question

Topics

High-Performing Database Solutions

More questions from this topic