Question 440
A SQL report should compute a percent-of-total measure while preserving row-level region totals. What should the acceptance test demonstrate?
Explanation
Correct Answer
This directly verifies the intended outcome: Window totals can provide denominators without losing regional rows. The accepted result is: Region percentages sum to the expected total across the selected population.
Incorrect Answers
Per-region detail disappears.
All rows become 100%.
Percentages use incompatible units.