TenX interview question

Data warehousing architecture and some sql queries.