Q2 — AWS SAP-C02 Ch.3

Question 2 of 75 | ← Chapter 3

Q227. A company wants to migrate its on-premises application to AWS. The database for the application stores structured product data and temporary user session data. The company needs to decouple the product data from the user session data.The company also needs to implement replication in another AWS Region for disaster recovery. Which solution will meet these requirements with the HIGHEST performance?

Correct Answer: B. Create an Amazon RDS DB instance to host the product data. Configure a read replica for the DB instance in another Region. Create a global datastore in Amazon ElastiCache for Memcached to host the user session data.

Explanation

This solution separates the product data and the user session data into different services while providing high performance and low latency. The product data is stored in an Amazon RDS DB instance, which provides a high-performance database solution with configurable replicas for disaster recovery purposes. The user session data can be stored in an Amazon ElastiCache for Memcached cluster, which is optimized for in-memory data caching and provides fast access to frequently accessed data. This approach also allows for global replication across Regions for both services, ensuring that the application remains highly available and responsive to users. Option A suggests creating an Amazon RDS DB instance with separate schemas to host the product data and the user session data and configuring a replica in another Region. However, this approach may not provide the best performance since the user session data is still stored in the same database instance as the product data. Option C suggests using two Amazon DynamoDB global tables to host the product data and user session data, respectively. Although DynamoDB is a fast and scalable NoSQL database service, it may not be the best choice for structured data storage, and the use of DynamoDB Accelerator (DAX) for caching may add unnecessary complexity. Option D suggests using an Amazon RDS DB instance to host the product data and a DynamoDB global table to host the user session data. Although this approach separates the product data from the user session data, it may not provide the best performance for the user session data since DynamoDB may not be optimized for frequently accessed in-memory data. Therefore, option B provides the most suitable solution with the highest performance by separating the product data and user session data into different services, using Amazon RDS for structured product data storage, ElastiCache for Memcached for in-memory caching of temporary user session data, and configuring global replication across Regions for both services, ensuring high availability and responsiveness.