Deloitte interview question

Redshift architecture, comparison with Snowflake, Snowpipe Program to load data from Redshift to S3, transformations and back to Redshift