Get Your CertDEA-C01PlayCompete
‹ All DEA-C01 questions

DEA-C01 Practice Question 83: Redshift Streaming Ingestion Kinesis

AWS Certified Data Engineer – Associate (DEA-C01) · Test 9 · question 3 of 10

Data Ingestion and Transformationmedium

Clickstream events arrive in an Amazon Kinesis data stream. Analysts need the events queryable in Amazon Redshift within seconds, and the team does not want an Amazon S3 staging layer or a COPY schedule to maintain. Which solution meets these requirements?

Select one answer
Show answer and explanation

Answer:

  • A. Create a materialized view over the Kinesis stream by using Redshift streaming ingestion.

Redshift streaming ingestion provides *"low-latency, high-speed data ingestion from Amazon Kinesis Data Streams or Amazon Managed Streaming for Apache Kafka"* into a Redshift provisioned or Serverless database. The data lands in a materialized view that is refreshed (or auto-refreshed) and flows *"directly from a data-stream provider"*; *"there isn't a temporary landing area, such as an Amazon S3 bucket"* (option A).

- B is wrong because an hourly COPY from S3 is a batch design with an S3 staging layer and up to an hour of latency. - C is wrong because it also stages data in S3 and reads it through Spectrum, which adds latency and one more job to operate. - D is wrong because AWS DMS does not use a Kinesis data stream as a source for replication into Redshift. Streaming ingestion is the feature built for this purpose.

Reference: Streaming ingestion to a materialized view

Practice Test 9 ›

Study guides for DEA-C01

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
Microsoft Fabric certification: DP-700 vs DP-600Microsoft Fabric certification means two exams, DP-600 and DP-700. Their roles, skills, format, cost in India, and which one to take first.
Databricks Data Engineer Associate vs AWS DEA-C01Databricks Data Engineer Associate vs AWS Certified Data Engineer – Associate - format, cost, topics and which one to take for your job, as of 2026.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.