Advanced Data Modelling

In Power BI, how can you create a relationship between two tables?

• Using VBA macros

• Creating a calculated column

• Defining a relationship in the model

• Using the Power Query Editor

Which of the following best describes Power Query in Power BI?

• A data visualization tool

• A query language for databases

• A data transformation and connection tool

• A programming language

Which option allows you to hide a relationship in Power BI's diagram view?

• Delete the relationship.

• Delete the relationship.

• Right-click and choose "Hide"

• Inactive the relationship.

Which Power BI View help us see and edit the Relationship between the tables?

• Report View

• Data View

• Model View

• Query Editor

What is the difference between a fact table and a dimension table?

• Fact tables contain observational data while dimension tables contain information about specific entities within the data.

• Fact tables contain information about specific entities while dimension tables contain information about observational data.

• There is no difference.

Choose the best answer to explain relationship cardinality?

• Cardinality is the measure of unique values in a table.

• Cardinality is the granularity of the data.

• Cardinality is how long it takes for the data to load.

If you have two queries that have different data but the same column headers, and you want to combine both tables into one query with all the combined rows, which operation should you perform?

• Append

• Merge

• Combine Column