Question 6 - Top Amazon/AWS DEA-C01 Real Exam Questions [Jan 2026 Update]

Q: 6

A company loads transaction data for each day into Amazon Redshift tables at the end of each day. The company wants to have the ability to track which tables have been loaded and which tables still need to be loaded. A data engineer wants to store the load statuses of Redshift tables in an Amazon DynamoDB table. The data engineer creates an AWS Lambda function to publish the details of the load statuses to DynamoDB. How should the data engineer invoke the Lambda function to write load statuses to the DynamoDB table?

Options

Correct Answer:

Explanation

The most direct and efficient method to trigger the Lambda function after a Redshift load is by using the native integration between the Amazon Redshift Data API and Amazon EventBridge. When an asynchronous SQL statement executed via the Redshift Data API completes, it automatically emits a "Redshift Data API Statement Status Change" event to EventBridge. A rule can be configured in EventBridge to listen for these specific events (e.g., for a SUCCEEDED or FAILED status). This rule can then directly invoke the target Lambda function, providing it with the context of the completed job. This creates a decoupled, event-driven, and serverless workflow.

References

1. AWS Documentation: Using the Amazon Redshift Data API. "When a statement finishes

the Data API emits an event to Amazon EventBridge. You can create rules in EventBridge to take action when it receives an event." This confirms the direct integration path.

Source: AWS Documentation

Amazon Redshift Database Developer Guide

"Monitoring events with Amazon EventBridge".

2. AWS Documentation: Amazon Redshift Data API events. This page details the specific event

"Redshift Data API Statement Status Change

" that is sent to the default event bus in EventBridge when a statement changes state.

Source: AWS Documentation

Amazon EventBridge User Guide

"AWS service events"

"Amazon Redshift Data API events".

3. AWS Big Data Blog: Automate and operationalize your Amazon Redshift data loading. This official blog post explicitly describes the architecture in the correct answer. It states

"When the statement is complete

the Data API sends an event to Amazon EventBridge. You can create an EventBridge rule that looks for events from the Data API."

Source: AWS Big Data Blog

"Automate and operationalize your Amazon Redshift data loading"

published November 18

2021. Section: "Solution overview".

4. AWS Documentation: Invoking AWS Lambda functions. This document lists Amazon EventBridge (CloudWatch Events) as a primary

supported event source for invoking Lambda functions synchronously or asynchronously.

Source: AWS Documentation

AWS Lambda Developer Guide

"Using AWS Lambda with other services"

"Invoking Lambda functions".

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE