Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/10
Score 0
What are the two ways to create data models in Power BI?
30
Write code or use a GUI.
Use SQL or Power Query.
Use a flat table or a relational table.
Import a data model or create your own data model.
Q 2/10
Score 0
What are the disadvantages of using flat tables in Power BI?
30
Requires more storage space and takes longer to load.
Not visually appealing and less intuitive.
Poor performance and poor usability.
Difficult to create and difficult to maintain.
10 questions
Q.
What are the two ways to create data models in Power BI?
1
30 sec
Q.
What are the disadvantages of using flat tables in Power BI?
2
30 sec
Q.
What is the process of normalizing data?
3
30 sec
Q.
Which type of table typically changes frequently?
4
30 sec
Q.
What are the three types of relationships between tables in Power BI?
5
30 sec
Q.
How can many-to-many relationships be avoided in Power BI data models?
6
30 sec
Q.
What happens when you create a one-to-one relationship between two tables with a small dataset, and one of the tables grows over time?
7
30 sec
Q.
What does the warning message "This relationship has cardinality many to many and this should only be used if it is expected that neither column contains unique values" mean?
8
30 sec
Q.
Which type of table typically changes frequently?
9
30 sec
Q.
What are the disadvantages of using flat tables in Power BI?