Q45 — AWS SAA-C03 Ch.17

Question 45 of 89 | ← Chapter 17

Q1345. A retail company stores customer behavior and session activity in Amazon DynamoDB. The company wants to run SQL queries in Amazon Redshift to track customer trends with regular updates. The company needs to automatically replicate the data to Amazon Redshift without developing or managing extract, transform, and load(ETL) pipelines.Which solution will meet these requirements with the LEAST operational overhead?

• A. Use AWS Glue to run ETL jobs on a schedule that extracts data from DynamoDB and loads the data into Amazon Redshift.
• B. Use DynamoDB Streams with AWS Lambda functions to send updates to Amazon Redshift in near real time.
• C. Use Amazon Redshift Spectrum to query data exported from DynamoDB to Amazon S3.
• D. Create a zero-ETL integration between DynamoDB and Amazon Redshift. ✓

Correct Answer: D. Create a zero-ETL integration between DynamoDB and Amazon Redshift.

Explanation

The correct solution is D. Create a zero-ETL integration between DynamoDB and Amazon Redshift.Explanation:Requirement: The company needs to automatically replicate DynamoDB data to Amazon Redshift for SQL querying without developing or managing ETL pipelines (minimal operational overhead).Why Option D is correct:Zero-ETL Integration: AWS recently introduced zero-ETL integrations between DynamoDB and Amazon Redshift, enabling near real-time data replication without requiring custom ETL pipelines. Fully Managed: AWS handles the replication process, reducing operational overhead (no need for AWS Glue, Lambda, or manual S3 exports).SQL Querying: Once replicated, data can be queried directly in Redshift using SQL.Why the other options are incorrect:A. Use AWS Glue to run ETL jobs on a scheduleRequires developing and managing ETL pipelines, increasing operational overhead.Not fully automated (needs scheduling and maintenance).B. Use DynamoDB Streams with AWS Lambda functionsRequires custom Lambda code to process streams and load into Redshift, increasing complexity. Still involves some ETL management (error handling, retries, etc.). C. Use Amazon Redshift Spectrum to query data exported to Amazon S3 Requires manual exports from DynamoDB to S3 (e.g., using DynamoDB Export or AWS Data Pipeline).Not a real-time or automated replication solution.Conclusion:Option D (Zero-ETL Integration) is the best choice because it provides fully automated, near real-time replication from DynamoDB to Redshift with no ETL development or management required, minimizing operational overhead.