Finance analysts need columnar scans across years of utility usage for ad-hoc reports. Cashiers still need single-row transactional updates on active accounts. Which design keeps each engine in its lane?
Select an answer to reveal the explanation.
Short Explanation
Warehouses are for leafing through years of usage history; cash registers are for one account at a time. Redshift handles the big columnar questions—leave the single-row postings on an OLTP database.
Full Explanation
Amazon Redshift is a columnar data warehouse optimized for analytical scans over large historical datasets such as utility usage. Single-row transactional OLTP belongs on Aurora, RDS, or DynamoDB depending on the access pattern. Using Redshift as a cashier OLTP store, replacing OLTP with cache-only data, or using SQS as a database are incorrect architectures.