nerdexam
Microsoft

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.

Implement and manage data models

Question

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 should you remove?

Options

  • ASales[Sales Amount]
  • BSales[Row ID]
  • CSales[Sales ID]
  • DPlan[Row ID]

How the community answered

(56 responses)
  • A
    9% (5)
  • B
    71% (40)
  • C
    16% (9)
  • D
    4% (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.

ASales[Sales Amount]

Sales[Sales Amount] is a critical measure column used for analysis and reporting, and removing it would compromise essential business metrics.

BSales[Row ID]Correct

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.

CSales[Sales ID]

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.

DPlan[Row ID]

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

#Data Model Optimization#Model Size Reduction#Column Management#Data Modeling Best Practices

Community Discussion

No community discussion yet for this question.

Full DP-500 Practice