Question 230
A data analyst is planning a Power BI solution. The business says: A customer dimension has a field CountryCode used for joins and CountryName used for slicer display. Which step best satisfies this request?
Explanation
Correct Answer
This directly addresses the stated constraint. Relationship keys and presentation labels serve different purposes. Confirmation: Changing a country display label does not break relationships to historical sales.
Incorrect Answers
ALL on every model table would remove unrelated geographic and temporal filtering. The specific problem here is that joining facts to mutable display names can create unmatched historic rows.
A standard SUM across every daily snapshot inflates stock and misstates the month-end position. The specific problem here is that joining facts to mutable display names can create unmatched historic rows.
Rewriting DAX blindly when most time is visual rendering may have little effect. The specific problem here is that joining facts to mutable display names can create unmatched historic rows.