Microsoft Power BI Data Analyst — Question 75

You have a Power BI semantic model that contains two tables named DimCustomer and FactOrderDetails.

The primary key of DimCustomer is CustomerID.

FactOrderDetails contains a column named CustomerID that can be used to relate to DimCustomer. Multiple rows in FactOrderDetails possibly have the same CustomerID value.

You need to create a relationship from FactOrderDetails to DimCustomer. The solution must optimize query performance.

What should you create?

Answer options

• A. an active, single-direction, many-to-one relationship
• B. an inactive, single-direction, one-to-many relationship
• C. an active, single-direction, one-to-many relationship
• D. an active, bi-directional, many-to-one relationship

Correct answer: A

Explanation

The correct answer is A because creating an active, single-direction, many-to-one relationship from FactOrderDetails to DimCustomer allows for efficient querying while ensuring that the relationship flows from the fact table to the dimension table. Options B and C are incorrect as they do not provide the necessary performance optimization, and option D is not suitable because a bi-directional relationship can lead to ambiguous paths in queries.