This is a dedicated watch page for a single video.
A prominent retail chain accumulates daily sales data dumps from each outlet into Amazon S3. The requirement is to execute daily analytical reports on sales trends spanning the previous 30 days. Furthermore, the data is to be archived post-90 days. Which architectural solution ensures rapid data querying and efficient archiving at minimal costs?