Lightfoot interview question

Questions regarding ETL and Real Time Data. SQL query optimization and AWS