Data Modelling in Power BI

What is the primary purpose of data modelling in Power BI?

• To create visualisations

• To organise and structure data

• To write DAX formulas

• To share reports

Which of the following is a key component of a Power BI data model?

• Dataflows

• Dashboards

• Relationships

• Reports

In Power BI, what is a schema primarily used for?

• To define the structure of a database

• To create visualisations

• To write DAX formulas

• To share reports

Which type of relationship is most commonly used in Power BI data models?

• One-to-One

• One-to-Many

• Many-to-Many

• Many-to-One

What is the role of a primary key in a database schema?

• To create visualisations

• To uniquely identify each record

• To write DAX formulas

• To share reports

In Power BI, what is a 'fact table' primarily used for?

• Storing detailed transactional data

• Storing metadata

• Storing summary data

• Storing user information

Which of the following is NOT a type of join used in Power BI?

• Inner Join

• Outer Join

• Left Join

• Cross Join

In schema design, what is the purpose of a 'dimension table'?

• To store transactional data

• To store descriptive attributes related to fact data

• To store metadata

• To store user information

Which of the following is a best practice for data modelling in Power BI?

• Avoid using relationships

• Use as many tables as possible

• Normalise data to reduce redundancy

• Avoid using DAX formulas