Macquarie Group interview question

Scenario questions around data pipelines and data modelling