Understanding Power BI Data Models

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

• To create visualisations

• To connect tables and enable data analysis

• To format data

• To import data

Which of the following is a valid data type in Power BI?

• Integer

• Text

• Date/Time

• All of the above

What is the First Normal Form (1NF) in data normalisation?

• Ensuring that all columns contain atomic values

• Removing duplicate rows

• Creating foreign keys

• Ensuring that all tables have a primary key

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

• Decimal Number

• Boolean

• Image

• Currency

What is the Second Normal Form (2NF) in data normalisation?

• Ensuring that all non-key attributes are fully functional dependent on the primary key

• Removing all duplicate columns

• Ensuring that all tables have a primary key

• Creating foreign keys

In Power BI, what does a 'one-to-many' relationship signify?

• One row in the first table relates to one row in the second table

• One row in the first table relates to multiple rows in the second table

• Multiple rows in the first table relate to one row in the second table

• Multiple rows in the first table relate to multiple rows in the second table

Which of the following is a benefit of data normalisation?

• Reduces data redundancy

• Increases data redundancy

• Makes data entry faster

• Increases data storage requirements

What is the Third Normal Form (3NF) in data normalisation?

• Ensuring that all non-key attributes are not only fully functional dependent on the primary key but also on no other non-key attributes

• Removing all duplicate rows

• Ensuring that all tables have a primary key

• Creating foreign keys

In Power BI, what is a 'calculated column'?

• A column that is imported from the data source

• A column that is created by a DAX formula

• A column that is hidden from the report view

• A column that contains only text data

What is the purpose of a 'foreign key' in a data model?

• To uniquely identify each row in a table

• To create a relationship between two tables

• To store large amounts of text data

• To perform calculations on data