Q 1. You're working on a data archival solution to store log data from an application. It's absolutely critical that no data is lost, and it needs to be immediately accessible when it is infrequently demanded with overall costs minimized. What storage option is the best solution?
Your team has migrated the corporate data warehouse to Redshift, and so far all the data coming into the ETL pipeline for the data warehouse has been from other corporate systems also running on AWS. However, A new third party will be securely sending files directly to S3, and the data in these files need to be ingested into S3 elsewhere. What are the most efficient and best-automated way to introduce this change into the ETL pipeline?
Note: There can be multiple correct answers to this question.