Kabam interview question

Mainly about data modelling, query optimization and dbt