PL-300 Question #473: Real Exam Question with Answer & Explanation

Question

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?

Options

• Aan active, single-direction, many-to-one relationship
• Ban inactive, single-direction, one-to-many relationship
• Can active, single-direction, one-to-many relationship
• Dan active, bi-directional, many-to-one relationship

Explanation

There is a many-to-one relationship between the FactOrderDetails to DimCustomer tables. Bi-directional relationship guidance A bi-directional relationship is one that filters in both directions. Generally, we recommend that you minimize the use of bi-directional relationships. That's because they can negatively impact on model query performance, and possibly deliver confusing experiences for your report users. [Not D] There are three scenarios when bi-directional filtering can solve specific requirements: Special model relationships Slicer options "with data" Dimension-to-dimension analysis https://learn.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering

No community discussion yet for this question.