How to stream Kinesis Data Streams to Redshift Serverless with least overhead?
Short answer
B Use Amazon Redshift streaming ingestion to consume Kinesis Data Streams directly into materialized views for near real-time and previous-day analytics.
Question
Key Takeaways
Tests whether you know Redshift streaming ingestion reads Kinesis Data Streams directly; the trap is selecting Kinesis Data Firehose or S3 COPY, which add latency and intermediate steps.
This DEA-C01 question asks how to feed Kinesis Data Streams into Amazon Redshift Serverless for near real-time analytics of current and previous-day data with the least operational overhead. Redshift streaming ingestion is correct (B) because it consumes Kinesis directly into materialized views without extra ETL services.
Common mistake: Many candidates choose Kinesis Data Firehose (A) as the familiar Redshift loading path, but Firehose buffers through S3 and COPY and is not the least-overhead near-real-time solution.
Expert Analysis
Why the Answer Is Correct
Option B is correct because Amazon Redshift streaming ingestion consumes records directly from Kinesis Data Streams into materialized views, enabling near real-time queries without managing intermediate services. The same Redshift Serverless warehouse can store historical tables and join them with streaming materialized views, satisfying the requirement for both current and previous-day analytics. Because this is a native Redshift capability, it minimizes the operational overhead compared with Firehose-plus-COPY pipelines. Community commenter rralucard_ linked the official AWS documentation and highlighted that the feature "simplifies the architecture by eliminating the need for intermediate steps or services," and other learners (ssnei, 4c78df0, lucas_rfsb) also selected B.
Why the Other Options Are Wrong
Option A places Kinesis Data Firehose in the path, but Firehose buffers records and typically delivers to Redshift through S3 and COPY, which adds latency and extra components. Option C uses Amazon S3 plus the COPY command, a batch-oriented approach that cannot provide near real-time analytics and requires you to manage staging and load scheduling. Option D uses the Aurora zero-ETL integration with Amazon Redshift, which is designed for replicating Aurora transactional data rather than ingesting Kinesis Data Streams. Therefore, none of these alternatives meet the near real-time and least-operational-overhead requirements as directly as option B.
Community Comment Notes
The most upvoted comment, from rralucard_ with 7 likes, provides the AWS documentation link for materialized-view streaming ingestion and notes that it "simplifies the architecture by eliminating the need for intermediate steps or services." Several other commenters (ssnei, 4c78df0, and lucas_rfsb) also answered option B, reinforcing that Redshift streaming ingestion is the expected DEA-C01 pattern for this scenario. No comment argued for Firehose, S3 COPY, or Aurora zero-ETL as the least-overhead solution. The linked AWS documentation remains the authoritative reference for the feature tested here.
Official Reference
https://docs.aws.amazon.com/redshift/latest/dg/materialized-view-streaming-ingestion.html
This link opens the official vendor documentation in a new tab.
Exam Strategy
For "least operational overhead" questions, eliminate options that require you to manage intermediate storage, ETL jobs, or batch schedules. Redshift streaming ingestion is a native feature that reads Kinesis Data Streams directly, so it beats Firehose plus COPY and Aurora zero-ETL, which targets transactional databases instead of streaming ingestion.
Frequently Asked Questions
Why is Kinesis Data Firehose not the least-overhead choice here?
Can Redshift query both streaming data and the previous day's data?
Community Votes
100% of anonymous learners picked answer B. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 4 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.
From public community threads 4
-
rralucard_ 👍 7 Answered Bhttps://docs.aws.amazon.com/redshift/latest/dg/materialized-view-streaming-ingestion.html Use the Streaming Ingestion Feature of Amazon Redshift: Amazon Redshift recently introduced streaming data ingestion, allowing Redshift to consume data directly from Kinesis Data Streams in near real-time. This feature simplifies the architecture by eliminating the need for intermediate steps or services, and it is specifically designed to support near real-time analytics. The operational overhead is minimal since the feature is integrated within Redshift.
-
4c78df0 👍 1 Answered BB is correct
-
lucas_rfsb 👍 1 Answered BI'd go in B
-
ssnei 👍 1option B
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All DEA-C01 Questions
Access 100 questions with complete answers and detailed explanations.
View Full DEA-C01 Practice Test →