Examkin

Question

Difficulty: EasyImproving Database and Caching Efficiency

A company runs a web application with a MySQL database hosted on Amazon RDS. The database is experiencing performance degradation due to a high volume of read and write requests for user session states. A solutions architect must improve database efficiency by moving the session state data to a dedicated caching layer. The caching solution must support multi-AZ replication to ensure session data is not lost if a primary cache node fails. Which caching and database optimization strategy should the solutions architect implement?

  1. A
    Migrate the session state data to an Amazon ElastiCache for Memcached cluster with automatic replication enabled.
  2. B
    Enable Multi-AZ deployment on the Amazon RDS MySQL database and configure the application to route read queries for session states to the standby replica.
  3. Migrate the session state data to an Amazon ElastiCache for Redis cluster with Multi-AZ replication enabled.Answer
  4. D
    Set up a cross-region Pilot Light database replication pattern using Amazon Aurora MySQL to synchronize the session data.

Answer

Migrate the session state data to an Amazon ElastiCache for Redis cluster with Multi-AZ replication enabled.
Migrating the session state data to an Amazon ElastiCache for Redis cluster with Multi-AZ replication enabled is the correct approach. Unlike Memcached, ElastiCache for Redis supports replication, Multi-AZ replication groups, and automatic failover, ensuring that session data remains available if a primary node fails.

Step-by-Step Solution

1
Analyze the application requirements for caching session states.
The requirement demands a caching layer that offloads session data from RDS MySQL and supports multi-AZ replication for high availability.
Identifying the caching requirements helps filter out incompatible services.
2
Evaluate the caching capabilities of ElastiCache for Memcached and ElastiCache for Redis.
Memcached is a simple, multi-threaded cache but lacks replication and Multi-AZ capabilities. Redis supports replication, Multi-AZ automatic failover, and data persistence.
This determines which caching engine meets the high availability requirement.
3
Select the correct ElastiCache engine and configuration.
Choose ElastiCache for Redis with Multi-AZ replication enabled.
Redis satisfies both the low-latency caching and the high-availability replication requirements.

Key Concept

Selecting the appropriate caching engine (Redis vs. Memcached) based on replication and persistence requirements.
Estimated Time:1m 0s
Rate this question

Topics

Improving Database and Caching Efficiency