Get Your CertDEA-C01PlayCompete
‹ All DEA-C01 questions

DEA-C01 Practice Question 65: Aurora Zero ETL Redshift

AWS Certified Data Engineer – Associate (DEA-C01) · Test 7 · question 5 of 10

Data Store Managementmedium

An order-management system stores transactions in an Amazon Aurora MySQL cluster. Analysts need dashboards in Amazon Redshift that reflect new orders within seconds to minutes. The data engineering team wants to avoid building and operating ETL pipelines and does not want analytic queries to run on the production database. The Aurora cluster and the Redshift warehouse are in the same Region. Which solution meets these requirements with the least operational effort?

Select one answer
Show answer and explanation

Answer:

  • B. Create an Aurora zero-ETL integration with Amazon Redshift.

An Aurora zero-ETL integration with Amazon Redshift *"enables near real-time analytics and machine learning (ML) using data from Aurora"* and is *"a fully managed solution for making transactional data available in your analytics destination after it is written to an Aurora DB cluster."* It *"eliminate[s] the need to build and maintain complex data pipelines"*, and analytic queries run in Redshift rather than on the source cluster (option B). The source cluster must be in the same Region as the target, which is the case here.

- A is wrong because an hourly batch job is not near real-time, and the team would have to build and operate the pipeline and its incremental logic. - C is wrong because a read replica is still an OLTP database. It does not put the data in Redshift, and a cross-Region replica adds latency and cost for no benefit here. - D is wrong because a nightly full load produces data that is up to a day old and repeatedly copies the entire dataset.

Reference: Aurora zero-ETL integrations

Practice Test 7 ›

Study guides for DEA-C01

AWS Developer Associate exam guide: DVA-C02 to DVA-C03AWS Developer Associate exam: DVA-C02 ends 30 November 2026 and DVA-C03 starts 1 December. What changes, which to sit, format, price and study plan.
How AWS Certification Exams Work: Scoring and RenewalHow AWS certification exams work: levels, booking, question types, unscored questions, scaled scores, pass marks, validity and how recertification works.
What Is Amazon RDS? Multi-AZ, Read Replicas and BackupsWhat is Amazon RDS? Engines, Multi-AZ, read replicas, backups, RDS Proxy, Aurora and pricing explained, with the traps that AWS exams set around each one.
Microsoft Fabric certification: DP-700 vs DP-600Microsoft Fabric certification means two exams, DP-600 and DP-700. Their roles, skills, format, cost in India, and which one to take first.
Databricks Data Engineer Associate vs AWS DEA-C01Databricks Data Engineer Associate vs AWS Certified Data Engineer – Associate - format, cost, topics and which one to take for your job, as of 2026.
Which AWS certification should you get? 2026 roadmapWhich AWS certification to get first, by role and experience, with each exam's status in October 2026, what is changing, and prices in USD and INR.
What Is AWS Glue? Data Catalog, Crawlers and ETL JobsWhat is AWS Glue? The Data Catalog, crawlers, ETL jobs and DPUs, workflows, streaming, job bookmarks, Flex and Data Quality, plus the traps AWS exams set.