SAA-C03 Q31 · Analytics

Question

A company is designing an application on AWS that provides real-time dashboards. The dashboard data comes from on-premises databases that use a variety of schemas and formats. The company needs a solution to transfer and transform the data to AWS with minimal latency. Which solution will meet these requirements?

Accepted Answer

**Amazon MSK (Managed Streaming for Apache Kafka)** satisfies every requirement:

1. **Real-time with minimal latency**: Apache Kafka is purpose-built for real-time streaming. It processes events in milliseconds, making it ideal for real-time dashboards. MSK provides a fully managed Kafka service on AWS.

2. **Transfer from on-premises**: Kafka Connect, which is part of the Kafka ecosystem and supported by MSK, can use source connectors (e.g., JDBC connectors, Debezium CDC connectors) to pull data from on-premises databases in near real-time. MSK Connect is a managed service for running Kafka Connect workers.

3. **Variety of schemas and formats**: Kafka's stream processing capabilities (via Kafka Streams or integrations with tools like Apache Flink) allow transformation of data from diver

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips