AWS Certified Data Engineer Associate DEA-C01 Practice Question
A company ingests application events as JSON records into an existing Amazon Kinesis Data Stream. The data engineering team must build an ongoing pipeline that delivers every new record into an Amazon Redshift cluster for analytics. The solution must require the least custom code and must automatically handle schema changes in the incoming JSON. Which approach meets these requirements?
Develop an AWS Glue streaming ETL job that reads from the Kinesis Data Stream and writes the data to Amazon Redshift using the JDBC writer.
Create a streaming ingestion materialized view in Amazon Redshift that reads directly from the Kinesis Data Stream and stores the data in a column of type SUPER.
Create an Amazon Kinesis Data Firehose delivery stream that transforms the JSON with AWS Lambda and loads the data into Amazon Redshift.
Configure an AWS DMS task in full-load and change-data-capture mode with Kinesis Data Streams as the source endpoint and Amazon Redshift as the target endpoint.
Amazon Redshift streaming ingestion lets you create a materialized view that is bound to an Amazon Kinesis Data Stream. When the view is refreshed (manually or with auto-refresh), Redshift reads new records from the stream and lands them in cluster storage. Declaring the target column as the SUPER data type stores the JSON in schemaless form, so newly added attributes are ingested without altering the table. The approach is configured entirely with SQL and requires no additional code or infrastructure. AWS DMS cannot use a Kinesis stream as a source, Kinesis Data Firehose needs extra transformation logic or manual schema maintenance, and an AWS Glue streaming job or Lambda loader demands custom code and operations.
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 Amazon Redshift's SUPER data type?
Open an interactive chat with Bash
How does a materialized view work in Amazon Redshift for streaming ingestion?
Open an interactive chat with Bash
How does Amazon Redshift handle schema changes in JSON data with this approach?
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .