Examkin

Question

Difficulty: MediumAWS Database Services

A media broadcasting network is developing a news distribution platform. The platform has two requirements: first, it must store structured user subscription information and article metadata, allowing complex SQL queries and relational integrity; second, it must temporarily store and serve the most popular articles in memory to minimize read latency for visitors. Which AWS services should be selected to handle these data requirements? (Select TWO.)

  1. Amazon AuroraAnswer
  2. Amazon ElastiCacheAnswer
  3. C
    Amazon DynamoDB
  4. D
    Amazon Redshift
  5. E
    Amazon Simple Storage Service (Amazon S3)

Answer

Amazon Aurora and Amazon ElastiCache
Amazon Aurora provides a high-performance relational database that supports standard SQL queries and table joins, satisfying the requirement to store structured subscriptions and article metadata. Amazon ElastiCache functions as an in-memory caching layer that speeds up article access by storing popular content in RAM, reducing overall read latency.

Step-by-Step Solution

1
Identify the service required for structured relational data that involves complex SQL queries.
Amazon Aurora is selected as the relational database engine because it is fully compatible with MySQL and PostgreSQL and designed for complex relational transactional workloads.
The requirement specifies structured user subscription data and article metadata requiring complex SQL queries and relational integrity.
2
Identify the service required to cache popular articles in memory to reduce read latency.
Amazon ElastiCache is selected because it provides managed in-memory caching capabilities.
The requirement specifies storing popular articles in memory to minimize read latency for visitors.
3
Combine the selected services and eliminate inappropriate alternatives.
The final selection is Amazon Aurora and Amazon ElastiCache.
The other options represent NoSQL, data warehousing, or object storage services that do not align with the specific transactional relational and caching requirements.

Key Concept

Selecting AWS database services based on relational query requirements and low-latency cache requirements.
Estimated Time:1m 30s
Rate this question

Topics

AWS Database Services

More questions from this topic