LinkedIn Interview Question

Core concepts of Data warehousing. SQL based design question. SCD, star schema, facts, dimensions, etc.