AWS Certified Solutions Architect – Professional (SAP-C02) — Question 319

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?

Answer options

• A. Create an Amazon RDS DB instance with separate schemas to host the product data and the user session data. Configure a read replica for the DB instance in another Region.
• 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.
• C. Create two Amazon DynamoDB global tables. Use one global table to host the product data. Use the other global table to host the user session data. Use DynamoDB Accelerator (DAX) for caching.
• D. Create an Amazon RDS DB instance to host the product data. Configure a read replica for the DB instance in another Region. Create an Amazon DynamoDB global table to host the user session data.

Correct answer: D

Explanation

Amazon RDS with a cross-region read replica is ideal for hosting structured product data while meeting disaster recovery requirements. Decoupling the temporary user session data to an Amazon DynamoDB global table provides high-performance, low-latency access and automatic multi-region replication. Option B is incorrect because Amazon ElastiCache for Memcached does not support global datastores, whereas Option A fails to decouple the data sources.