SAP-C02 Q542 · Database

Question

A company is developing an application that will display financial reports. The company needs a solution that can store financial Information that comes from multiple systems. The solution must provide the reports through a web interface and must serve the data will less man 500 milliseconds or latency to end users. The solution also must be highly available and must have an RTO or 30 seconds. Which solution will meet these requirements?

Accepted Answer

Option C meets all requirements systematically:

1. **Store financial data from multiple systems**: Amazon DynamoDB is a fully managed NoSQL database that can ingest data from multiple sources. Its flexible schema makes it easy to consolidate different financial data formats.

2. **Less than 500ms latency**: DynamoDB provides **single-digit millisecond latency** at any scale. This is well within the 500ms requirement. QuickSight with DirectQuery datasets queries DynamoDB in real-time, and QuickSight's in-memory computation engine (SPICE or DirectQuery) can render dashboards quickly.

3. **Highly available**: DynamoDB is inherently highly available — it replicates data across **three Availability Zones** automatically within a Region. There's no infrastructure to manage or failover to confi

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips