Question 80
A company is planning an AWS architecture with this constraint: Reporting queries need a columnar warehouse over years of historical facts and are largely analytical rather than transactional. Which change should the architect recommend?
Explanation
Correct Answer
Columnar analytical warehouses optimize large aggregations differently from OLTP relational databases. This design addresses the specific constraint: Reporting queries need a columnar warehouse over years of historical facts and are largely analytical rather than transactional. A meaningful acceptance check is: A historical multi-billion row aggregate completes within reporting SLA without affecting order transactions.
Incorrect Answers
Time-indexed storage patterns differ from generic transactional relational models for telemetry.
Key-based Query patterns scale better than repeated scans for selective access.
Database proxies reduce repeated connection setup and limit connection storms from serverless clients.