Check your knowledge

Completed

Answer the following questions to see what you've learned.

1.

What benefit do you get from analyzing the metadata?

The benefit of analyzing the metadata is that you can clearly identify data inconsistences with your semantic model.

The benefit of analyzing the metadata is to get familiar with your data.

The benefit of analyzing the metadata is to know the number of rows, columns and tables being loaded into your model.

2.

What can be achieved by removing unnecessary rows and columns?

It is not necessary to delete unnecessary rows and columns and it is a good practice to keep all metadata intact.

Deleting unnecessary rows and columns will reduce a semantic model size and it's good practice to load only necessary data into your semantic model.

Deleting unnecessary rows and columns can damage the structure of the semantic model.

3.

Which of the following statements about relationships in Power BI Desktop is true?

Relationships can only be created between columns that contain the same data type.

Relationships can only be created between tables that contain the same number of rows.

Relationships can be created between tables that contain different types of data.

You must answer all questions before checking your work.