Question 80
A solution was implemented for this need: A sales model includes an OrderLines fact and a Customers dimension, but a preexisting bidirectional path through Returns creates ambiguity. The selected approach was: Review relationships and disable unnecessary bidirectional filter paths while keeping an unambiguous star design. Which result most directly proves it worked?
Explanation
Correct Answer
This checks the actual result rather than a saved setting. Ambiguous relationship paths can yield unexpected context and should be simplified. A failed implementation may show: Adding another Both-direction relationship increases the ambiguity of filter propagation.
Incorrect Answers
A two-line order counts once and month filters restrict the distinct order set. However, this does not establish the required outcome: a customer selection produces one predictable filter path and correct total sales.
The table can render permitted URL values as navigable links. However, this does not establish the required outcome: a customer selection produces one predictable filter path and correct total sales.
A contiguous date row exists for each day from the first through last transaction date. However, this does not establish the required outcome: a customer selection produces one predictable filter path and correct total sales.