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

A healthcare company uses Amazon Kinesis Data Streams to stream real-time health data from wearable devices, hospital equipment, and patient records.
A data engineer needs to find a solution to process the streaming data. The data engineer needs to store the data in an Amazon Redshift Serverless warehouse. The solution must support near real-time analytics of the streaming data and the previous day's data.
Which solution will meet these requirements with the LEAST operational overhead?

Answer options

• A. Load data into Amazon Kinesis Data Firehose. Load the data into Amazon Redshift.
• B. Use the streaming ingestion feature of Amazon Redshift.
• C. Load the data into Amazon S3. Use the COPY command to load the data into Amazon Redshift.
• D. Use the Amazon Aurora zero-ETL integration with Amazon Redshift.

Correct answer: B

Explanation

The correct answer is B because using the streaming ingestion feature of Amazon Redshift allows for direct integration with Kinesis Data Streams, enabling real-time analytics with minimal delay and operational overhead. Options A, C, and D involve additional steps or services that would increase complexity and operational management, making them less ideal for this scenario.