Exam DP-600 Topic 2 Question 198 Discussion

Actual exam question for Microsoft's DP-600 exam
Question #: 198
Topic #: 2
You have the following T-SQI statement.

Suggested Answer:


Explanation:

The statement uses SUM(CASE WHEN RefundStatus = 'Refunded' THEN SalesAmount ELSE 0 END) AS TotalRevenue, which calculates TotalRevenue by summing SalesAmount only when RefundStatus is
'Refunded', and 0 otherwise. This means Region values are returned regardless of RefundStatus, but the TotalRevenue reflects refunded items.
The WHERE (TransactionDate) - YEAR(GETDATE()) condition is incomplete and lacks proper comparison (e.g., no equality or range check), so it does not filter for the current year.
The TotalRevenue calculation does not aggregate all SalesAmount values with RefundStatus of 'Refunded'; it sums SalesAmount only for refunded items within the grouped data, with 0 for non-refunded items.

by Rupert at Aug 16, 2026, 01:20 PM

Limited Time Offer

15%

Off

Get Premium DP-600 Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10