
Data Modelling in Power BI | How to do Modelling in Power BI
Quiz by Nitin Gholap
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Measure skills
from any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
With a free account, teachers can
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
10 questions
Show answers
- Q1Which of the following statements is TRUE about Dimension Tables in Power BI?They are used to store aggregated data.They can have a relationship with multiple fact tables.They always have a primary key.They contain mostly numerical data.30s
- Q2What does the "star" in a star schema refer to?A specific type of dimension table.The central fact table.The connection between dimension tables.The snowflake schema.30s
- Q3How can you identify the primary key of a dimension table in Power BI?By checking the data profile of the table.The software automatically assigns a primary key.All columns can be considered primary keys.By looking for the column with the most distinct values.30s
- Q4What does an "inactive" relationship between two tables in Power BI mean?The relationship is not valid.The tables are not connected.Data can still be filtered, but the inactive relationship takes lower priority.Data cannot be filtered from one table to the other.30s
- Q5Which of the following is NOT a way to create a relationship between two tables in Power BI?Drag and drop a column from one table to the corresponding column in the other table.Automatically create relationships during data import (with specific settings).Use the "Manage Relationships" option in the Power BI ribbon.Write a custom formula to define the relationship.30s
- Q6What is the purpose of a lookup table in Power BI?To improve the visual appearance of charts and graphs.To store detailed information about specific categories.To define relationships between dimension tables.To perform calculations and aggregations.30s
- Q7How is a "one-to-many" relationship between two tables in Power BI represented visually?A double-headed arrow connects the two tables.There is no visual distinction between different relationship types.A single line connects the two tables, with a crow's foot on the "many" side.Both tables are shaded in the same color.30s
- Q8What is the advantage of using a star schema for data modelling in Power BI?It is more efficient for storing large datasets.It allows for faster calculations on aggregated data.It simplifies the process of creating relationships between tables.It is better suited for complex data hierarchies.30s
- Q9How can you tell if a dimension table column is being used as a filter in a relationship?The column will be highlighted in a specific color.The direction of the arrow in the relationship diagram will be reversed.There will be an additional icon next to the column name.The data profile of the column will show a higher number of distinct values.30s
- Q10What are some of the limitations of the star schema for data modelling?It is not suitable for all data structures.It cannot be used with hierarchical data.It requires a significant amount of storage space.It can become complex with many dimension tables.30s