SAP-C02 Q327 · Database

Question

A company wants to migrate its on-premises application to AWS. The database for the application stores structured product data and temporary user session dat a. 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?

Accepted Answer

This solution meets every requirement optimally:

1. **Structured product data → Amazon RDS**: Product data is structured/relational, making RDS the ideal choice. RDS excels at complex queries, joins, and transactions typical of product catalogs.

2. **Session data → DynamoDB global table**: Session data is temporary, key-value in nature (session ID → session blob), and requires low-latency reads/writes. DynamoDB is purpose-built for this pattern — single-digit millisecond performance at any scale.

3. **Decoupling**: By using two completely separate services (RDS for products, DynamoDB for sessions), the data is fully decoupled. Each service can scale independently, and a failure in one doesn't affect the other.

4. **Cross-Region DR**: 
   - RDS cross-region read replica provides DR for

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips