mediumMultiple ChoiceObjective-mapped

PL-900 Practice Question: Refer to the exhibit

Exhibit

Refer to the exhibit.

```
{
  "data": [
    {
      "table": "Sales",
      "columns": ["Date", "ProductID", "SalesAmount", "Region"],
      "rows": [
        ["2024-01-01", 101, 250.00, "North"],
        ["2024-01-01", 102, 150.00, "South"],
        ["2024-01-02", 101, 300.00, "North"]
      ],
      "relationships": [
        {"from": "Sales[ProductID]", "to": "Product[ProductID]"}
      ]
    },
    {
      "table": "Product",
      "columns": ["ProductID", "ProductName", "Category"],
      "rows": [
        [101, "Widget", "Tools"],
        [102, "Gadget", "Electronics"]
      ]
    }
  ]
}
```

Refer to the exhibit. A Power BI developer imported the JSON data into a Power BI data model. When creating a report, they notice that the 'Sales' table does not display the product name. What is the most likely cause?

⚠ Common exam trap

Test-takers frequently assume any defined relationship automatically works for all visuals, but Power BI requires the relationship to be active (solid line) for implicit measures and visual filters to propagate correctly, and inactive relationships are a common source of missing data in reports.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

The relationship between Sales and Product tables is not active or is misconfigured.

The most likely cause is that the relationship between the Sales and Product tables is either inactive or misconfigured. In Power BI, even when a relationship exists, if it is set to inactive (e.g., using a bidirectional filter or a different cardinality), the report will not automatically propagate the ProductName from the Product table to the Sales table. This prevents the product name from displaying in the report, even though the data is present in the model.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✗
No relationship is defined between the tables.
Why it's wrong here
A relationship is defined in the JSON.
✗
The Sales table and Product table are from different data sources.
Why it's wrong here
Both tables are in the same JSON data source.
✗
The 'ProductName' column is missing from the Product table.
Why it's wrong here
The Product table includes 'ProductName' column.
✓
The relationship between Sales and Product tables is not active or is misconfigured.
Why this is correct
The relationship must be active and correctly set to retrieve related product names.

Go deeper

PL-900 Practice Question: Refer to the exhibit

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question