Describe Dynamics 365 Supply Chain Management →mediumMultiple ChoiceObjective-mapped

MB-920 Describe Dynamics 365 Supply Chain Management Practice Question

Exhibit

Refer to the exhibit.

```
// KQL query for Power BI
// Count of quality orders by status
QualityOrders
| where CreationDate >= ago(30d)
| summarize Count = count() by Status
| order by Count desc
```

You are reviewing a Power BI report that shows quality order counts by status. The report shows 0 for 'Open' status even though there are open quality orders. What is the most likely reason?

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 query filters to only orders created in the last 30 days.

The Power BI report likely uses a filter that limits data to the last 30 days. Open quality orders may have been created earlier, so they are excluded from the report, resulting in a count of 0. Option A is wrong because open orders do exist, so the count is not actually zero. Option C is wrong because the 'CreationDate' field exists and is used for filtering. Option D is wrong because the 'Status' field is used in the report to categorize counts, but the filter on creation date is the cause.

Answer analysis

Option-by-option breakdown

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

✗
The count of open orders is actually zero.
Why it's wrong here
The user states there are open orders.
✓
The query filters to only orders created in the last 30 days.
Why this is correct
Open orders created more than 30 days ago are excluded.
✗
The 'CreationDate' field does not exist in the QualityOrders table.
Why it's wrong here
The query uses CreationDate, so it must exist.
✗
The 'Status' field is not used in the summarize.
Why it's wrong here
Status is used in the group-by clause.

Go deeper

MB-920 Describe Dynamics 365 Supply Chain Management Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question