data-engineer video for a data engineering team needs to process large volumes of transaction logs stored in Amazon S3 and load the transformed data into an
A data engineering team needs to process large volumes of transaction logs stored in Amazon S3 and load the transformed data into an Amazon Aurora PostgreSQL database for further analysis. The team wants to automate the transformation and loading process while ensuring minimal impact on the Aurora database's performance during peak hours. Which of the following solutions will best achieve these objectives?