DEA-C01 Data Store Management Practice Question
A data engineer is responsible for an Amazon Redshift cluster that ingests data continuously from Amazon Kinesis Data Streams. The engineer needs to ensure that the raw streaming data is immediately queryable in Redshift with minimal latency. Which approach should the engineer take?
⚠ Common exam trap
The trap here is assuming that Redshift Spectrum or federated query can directly access streaming data, but they are designed for querying external data in S3 or relational databases, not Kinesis streams.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use the Amazon Kinesis Data Firehose delivery stream to load data into Redshift.
Kinesis Data Firehose is the managed service for loading streaming data into Amazon Redshift. It buffers, compresses, and delivers data to an intermediate S3 bucket, then issues COPY commands to load into Redshift. This provides low-latency, near-real-time ingestion, making the data immediately available for querying. Other options either do not support Kinesis as a source or are not optimized for this scenario.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use the Amazon Kinesis Data Firehose delivery stream to load data into Redshift.
Why this is correct
Kinesis Data Firehose can deliver streaming data directly to Amazon Redshift, using an intermediate S3 bucket and issuing COPY commands. This provides near-real-time ingestion with minimal latency, making the data immediately queryable. Firehose handles buffering, compression, and retry logic, simplifying the pipeline.
- ✗
Use Amazon Redshift Spectrum to query the Kinesis stream directly.
Why it's wrong here
Redshift Spectrum allows querying external data in Amazon S3, not Kinesis streams. It cannot read directly from a streaming source. To make streaming data queryable, the data must first be materialized into Redshift tables or external tables over S3. Spectrum does not support Kinesis as a data source.
- ✗
Use Amazon Redshift federated query to query Kinesis Data Streams.
Why it's wrong here
Redshift federated query allows querying data in external databases like Amazon RDS or Aurora, not streaming services like Kinesis. It does not support Kinesis as a data source. To query streaming data, it must be loaded into Redshift first, typically via Firehose.
- ✗
Use AWS Database Migration Service (AWS DMS) to replicate from Kinesis to Redshift.
Why it's wrong here
AWS DMS is designed for migrating databases, not for ingesting streaming data from Kinesis. While DMS supports some streaming sources like Kinesis, it is not optimized for continuous low-latency ingestion into Redshift for analytics. Firehose is the recommended service for this use case.
Quick reference
AWS S3 Storage Class Comparison
| Storage Class | Min Duration | Retrieval | Use Case |
|---|---|---|---|
| S3 Standard | None | Immediate | Frequently accessed data |
| S3 Standard-IA | 30 days | Immediate | Infrequent access, rapid retrieval |
| S3 One Zone-IA | 30 days | Immediate | Non-critical infrequent data |
| S3 Intelligent-Tiering | None | Immediate–hours | Unknown or changing access patterns |
| S3 Glacier Instant | 90 days | Milliseconds | Archive with instant retrieval |
| S3 Glacier Flexible | 90 days | Minutes–hours | Archive, flexible retrieval |
| S3 Glacier Deep Archive | 180 days | Hours | Long-term compliance archive |
Go deeper
Related to this question
About these practice questions
This DEA-C01 question is part of Courseiva's 1,321-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Amazon Web Services exam blueprint
This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.