
Answer-first summary for fast verification
Answer: Use the streaming ingestion feature of Amazon Redshift.
Amazon Redshift streaming ingestion enables a data warehouse to directly consume and ingest streaming data from Amazon Kinesis Data Streams into materialized views. This bypasses the need for an intermediate staging layer like Amazon S3, allowing near real-time analytics with the absolute least operational overhead.
Author: Ritesh Yadav
Ultimate access to all questions.
Question 44
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.
No comments yet.