Q59 — AWS DEA-C01 Ch.1

Question 59 of 100 | ← Chapter 1

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?

• 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. Use the streaming ingestion feature of Amazon Redshift.

Explanation

为了满足近乎实时的数据流分析和前一天的数据分析需求，同时减少操作负担，最合适的方案是直接利用AmazonRedshift的流数据摄入功能。这一功能允许数据直接从AmazonKinesisDataStreams流入AmazonRedshift，无需中间存储或额外的数据处理步骤，从而降低了操作复杂性。因此，选项B是满足这些要求且操作负担最小的解决方案。