DP-500 · Question #78
The table relationships for the dataset are shown in the Relationships exhibit. (Click the Relationships tab.) You need to minimize the model size by eliminating invalid relationships. Which column…
The correct answer is B. Sales[Row ID]. To minimize model size and eliminate invalid relationships, the 'Sales[Row ID]' column should be removed if it's not used as a key for relationships.
Question
Options
- ASales[Sales Amount]
- BSales[Row ID]
- CSales[Sales ID]
- DPlan[Row ID]
How the community answered
(56 responses)- A9% (5)
- B71% (40)
- C16% (9)
- D4% (2)
Why each option
To minimize model size and eliminate invalid relationships, the 'Sales[Row ID]' column should be removed if it's not used as a key for relationships.
Sales[Sales Amount] is a critical measure column used for analysis and reporting, and removing it would compromise essential business metrics.
A 'Row ID' column in a fact table like 'Sales' is often an arbitrary internal identifier unique to each row that serves no analytical purpose for creating relationships with other tables. Removing such a column reduces model size and eliminates potential sources of unnecessary or invalid relationships, optimizing the data model.
Sales[Sales ID] is likely a primary key for the Sales fact table, crucial for identifying individual sales records and establishing valid relationships with dimension tables.
While 'Plan[Row ID]' could also be a candidate, 'Sales[Row ID]' is a common redundant column in fact tables when not explicitly used for relationships, and the question specifically targets eliminating invalid relationships to minimize model size, often associated with such non-key identifiers.
Concept tested: Power BI data modeling optimization, redundant columns
Source: https://learn.microsoft.com/en-us/power-bi/guidance/import-modeling-guidance#reduce-the-number-of-columns-and-rows
Topics
Community Discussion
No community discussion yet for this question.