AWS Certified Data Engineer – Associate (DEA-C01) — Question 257

A technology company currently uses Amazon Kinesis Data Streams to collect log data in real time. The company wants to use Amazon Redshift for downstream real-time queries and to enrich the log data.

Which solution will ingest data into Amazon Redshift with the LEAST operational overhead?

Answer options

• A. Set up an Amazon Kinesis Data Firehose delivery stream to send data to a Redshift provisioned cluster table.
• B. Set up an Amazon Kinesis Data Firehose delivery stream to send data to Amazon S3. Configure a Redshift provisioned cluster to load data every minute.
• C. Configure Amazon Managed Service for Apache Flink (previously known as Amazon Kinesis Data Analytics) to send data directly to a Redshift provisioned cluster table.
• D. Use Amazon Redshift streaming ingestion from Kinesis Data Streams and to present data as a materialized view.

Correct answer: D

Explanation

The correct answer is D because Amazon Redshift streaming ingestion allows for efficient real-time data transfer directly from Kinesis Data Streams with minimal operational overhead. Option A involves setting up a Firehose delivery stream, which adds complexity. Option B requires additional data loading configurations and a time delay, while option C introduces more components that may increase management efforts.