SAA-C03 Q443 · Analytics

Question

A company needs to collect streaming data from several sources and store the data in the AWS Cloud. The dataset is heavily structured, but analysts need to perform several complex SQL queries and need consistent performance. Some of the data is queried more frequently than the rest. The company wants a solution that meets its performance requirements in a cost-effective manner. Which solution meets these requirements?

Accepted Answer

Option D meets every requirement through a tiered architecture:

1. **Streaming data collection**: Amazon Data Firehose is a fully managed service purpose-built for ingesting streaming data. It's simpler and more cost-effective than Amazon MSK for pure data delivery scenarios.

2. **Structured data + Complex SQL + Consistent performance**: Amazon Redshift is a columnar data warehouse optimized for complex SQL queries on structured data with consistent, predictable performance.

3. **Some data queried more frequently than others**: This is the KEY differentiator. The solution creates a hot/cold tiered storage pattern:
   - **Hot data** (frequently queried): Loaded into Redshift using COPY command → fastest query performance
   - **Cold data** (less frequently queried): Stays in S3, queried

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips