A logistics company is building a new data platform that will ingest real-time streaming information from a variety of sources, including IoT devices and partner APIs. The data must be transformed before being stored in Amazon S3. Additionally, the company needs the ability to run SQL-based queries on the processed data. Which solutions provide a reliable and scalable architecture to meet these requirements?