🔥 3-day streak
AWS Certified Data Engineer - Associate140 / 159
Question 140 of 159
A company runs a transactional order-management application on Amazon Aurora PostgreSQL. The analytics team needs to run large, complex aggregation queries across billions of historical order rows spanning several years for quarterly business reports. These reports currently time out or severely slow down the production Aurora database. The data engineering team must provide a solution that offloads the heavy analytical workload while keeping the transactional system responsive, with minimal ongoing management. Which approach best meets these requirements?
Reviewed for accuracy · Report an issueNext question