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

Q: 17

A retail company stores order information in an Amazon Aurora table named Orders. The company needs to create operational reports from the Orders table with minimal latency. The Orders table contains billions of rows, and over 100,000 transactions can occur each second. A marketing team needs to join the Orders data with an Amazon Redshift table named Campaigns in the marketing team's data warehouse. The operational Aurora database must not be affected. Which solution will meet these requirements with the LEAST operational effort?

Options

Correct Answer:

Explanation

The most optimal solution is the Amazon Aurora zero-ETL integration with Amazon Redshift. This feature is specifically designed for near real-time analytics on operational data from Aurora within Redshift. It automates the complex process of building and managing data pipelines, thus fulfilling the requirement for the "LEAST operational effort." The integration continuously and automatically replicates data from Aurora to Redshift within seconds of being written, ensuring low latency for reporting without impacting the performance of the source operational Aurora database. Creating a materialized view in Redshift on this replicated data is the correct subsequent step for performant joins with the Campaigns table.

References

1. Amazon Aurora Documentation - Zero-ETL integrations: "Amazon Aurora zero-ETL integration with Amazon Redshift enables near real-time analytics and machine learning (ML) on petabytes of transactional data stored in Aurora. ... With a few clicks in the Amazon RDS console

you can create a zero-ETL integration... This fully managed solution eliminates the need for you to build and manage complex data pipelines that perform extract

transform

and load (ETL) operations."

Source: AWS Documentation

Working with Amazon Aurora zero-ETL integrations with Amazon Redshift

Introduction section.

2. Amazon Redshift Documentation - Zero-ETL integrations: "An Amazon Aurora zero-ETL integration with Amazon Redshift automatically and continuously replicates data... to an Amazon Redshift data warehouse. This replication enables you to perform analytics on your transactional data in near-real time... without having to build and maintain a data pipeline."

Source: AWS Documentation

Amazon Redshift Database Developer Guide

"Working with zero-ETL integrations"

Overview section.

3. AWS Documentation - Comparing Zero-ETL to other methods: The documentation implicitly positions zero-ETL as the simplest approach. While DMS and Glue are powerful

they are presented as solutions for more complex scenarios involving transformations or heterogeneous sources

which implies more setup. The very name "zero-ETL" is intended to convey minimal operational burden.

Source: AWS News Blog

Announcing Amazon Aurora zero-ETL integration with Amazon Redshift in preview

November 29

2022. This blog post contrasts the new feature with the "complex and manually intensive" process of building ETL pipelines.

Premium Access Includes

FLASH OFFER

avail 10% DISCOUNT on YOUR PURCHASE