Companies can ask you questions about design schemas in order to test your knowledge regarding the fundamentals of data engineering. Data Modelling consists of mainly two types of schemas: Star schema: Star schema consists of dimension tables that surround a fact table Snowflake schema: Snowflake schema also contains similar dimension tables surrounding a fact table which are further surrounded by dimension tables.