AWS Certified Data Engineer Associate DEA-C01 Practice Question
A retail company captures clickstream events in an Amazon Kinesis Data Stream. Business analysts need the events to be query-able in Amazon Redshift within one minute of being produced. The data engineering team wants the simplest solution that avoids intermediate storage and minimizes ongoing maintenance. Which approach best meets these requirements?
Configure an Amazon Kinesis Data Firehose delivery stream to load the data into Amazon Redshift on a 1-minute buffer interval.
Trigger an AWS Lambda function from the Kinesis Data Stream to batch records and insert them into Redshift via the Data API.
Create a materialized view in Amazon Redshift that performs streaming ingestion from the Kinesis Data Stream and enables AUTO REFRESH.
Build an AWS Glue streaming ETL job that reads from the Kinesis Data Stream and writes the records to Redshift through a JDBC connection.
Amazon Redshift supports native streaming ingestion from Amazon Kinesis Data Streams. By creating a materialized view that directly references the stream, Redshift continuously and automatically pulls new records without staging them in Amazon S3 or relying on additional services. The view can be set to AUTO REFRESH so data becomes query-able within seconds, satisfying the one-minute SLA with very little operational overhead.
Sending the stream through Kinesis Data Firehose or Glue adds an extra service and writes first to Amazon S3, increasing latency and management effort. A Lambda function that batches INSERT statements introduces custom code, scaling challenges, and higher maintenance compared with the managed Redshift feature.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is a materialized view in Amazon Redshift?
Open an interactive chat with Bash
How does Amazon Redshift support streaming ingestion from Kinesis Data Streams?
Open an interactive chat with Bash
Why is AUTO REFRESH important for streaming data in Amazon Redshift?
Open an interactive chat with Bash
What is a materialized view in Amazon Redshift?
Open an interactive chat with Bash
How does Amazon Redshift perform streaming ingestion from Kinesis Data Streams?
Open an interactive chat with Bash
Why is Kinesis Data Firehose not the best choice in this scenario?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Ingestion and Transformation
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .