Describe Dynamics 365 Finance →mediumMultiple ChoiceObjective-mapped

MB-920 Describe Dynamics 365 Finance Practice Question

Exhibit

Refer to the exhibit.

SELECT 
  MainAccount,
  SUM(Amount) as TotalAmount
FROM GeneralJournalEntry
WHERE PostingDate BETWEEN '2025-01-01' AND '2025-12-31'
GROUP BY MainAccount
HAVING SUM(Amount) > 10000
ORDER BY TotalAmount DESC;

Refer to the exhibit. The SQL-like query is used to retrieve data from Dynamics 365 Finance. What does this query return?

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

✓

Main accounts with total debits greater than 10,000, ordered by total descending.

The query selects MainAccount and sum of Amount from GeneralJournalEntry for a specific date range, groups by MainAccount, filters groups with total amount > 10000, and orders by total descending. Option A is wrong because it does not filter by a specific account. Option C is wrong because it returns only accounts with total > 10000. Option D is wrong because it is not ordered ascending.

Answer analysis

Option-by-option breakdown

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

✗
All general journal entries for a specific main account.
Why it's wrong here
The query groups by main account, not filters by one.
✓
Main accounts with total debits greater than 10,000, ordered by total descending.
Why this is correct
The query sums amounts and filters >10000.
✗
Main accounts with total amounts less than 10,000, ordered ascending.
Why it's wrong here
The filter is >10000 and order is descending.
✗
All main accounts with any activity in 2025.
Why it's wrong here
Only accounts with total > 10000 are returned.

Go deeper

MB-920 Describe Dynamics 365 Finance Practice Question

Exhibit

Why each option matters

Option-by-option breakdown

Related to this question