Question 970
A manufacturing business designs conformed facts and dimensions for sales analytics. The team implements Introduce a governed bridge table or appropriate allocation logic. The goal was: A many-to-many relationship between products and promotions causes duplicate fact joins. Which observed result best verifies success?
Explanation
Correct Answer
Fact revenue totals remain correct when analyzing multiple promotions directly measures whether Introduce a governed bridge table or appropriate allocation logic achieved the requirement “A many-to-many relationship between products and promotions causes duplicate fact joins.” It checks the operating result rather than just a configured resource name.
Incorrect Answers
This signal belongs to the adjacent case “A dimension is referenced before its first record arrives from the master system,” whose remedy is Use an unknown/inferred member and reconcile it later. The observed result for the present requirement is Fact revenue totals remain correct when analyzing multiple promotions.
That observation is a valid indicator for “A corrected dimension description should replace prior text with no requirement for history” when using Use SCD Type 1 overwrite semantics for that attribute. The scenario instead tests “A many-to-many relationship between products and promotions causes duplicate fact joins”; the relevant result is Fact revenue totals remain correct when analyzing multiple promotions.
Queries group facts by the correct date, product and store attributes would demonstrate the separate action Build a sales fact table linked to conformed dimensions by surrogate keys, which addresses “Revenue should be analyzed by date, product and store using a stable relational model.” It does not verify the requirement “A many-to-many relationship between products and promotions causes duplicate fact joins” following Introduce a governed bridge table or appropriate allocation logic.