Prepared with AI assistance by Pass-IT. Vendor sources support exam facts; the exercises and study recommendations are ours.
A revenue total is useful only when you can explain what belongs in it. For CompTIA Data+ DA0-002, practice making that decision before choosing a formula. The current certification covers data concepts and environments, acquisition and preparation, analysis, visualization and reporting, and governance. See the official certification page and linked objectives for the current scope.
Start with the business meaning
This original exercise uses fictional orders for one day. All amounts use the same currency, expressed in arbitrary units. The requested metric is revenue from completed, unique business orders.
| Order ID | Amount | Status |
|---|---|---|
| A | 40 | Complete |
| A | 40 | Complete |
| B | 60 | Complete |
| C | 20 | Cancelled |
The source owner confirms that each order represents one business order and that the second A is a duplicate delivery, not another line item. Write down your expected revenue and included order count before processing the rows.
The proposed answer is 100 units across 2 orders: retain A once, retain B, and exclude cancelled C. The calculation is 40 + 60 = 100. Adding every row gives 160 because it includes an extra 40 for A and 20 from the cancelled order.
Choose a rule you can defend
Filtering for completed orders alone leaves the duplicated A. Deduplicating alone leaves C. You need both rules, with the business meaning of the order identifier verified first. Deduplicating by customer would answer a different question: one customer can place several legitimate orders.
Preserve the source rows and an audit trail explaining the exclusions. Reconcile four source rows to two included orders, recording one duplicate delivery and one cancelled order. A data dictionary should define the identifier, amount, status values and reporting date. Record missing or invalid fields for review; replacing a missing amount with zero would silently change its meaning.
Now change one requirement: the second A is a genuine, separate line item with its own unique line identifier. Deduplicating by order ID would discard valid revenue. Confirm the reporting grain and revise the key. The earlier total of 100 no longer follows from the data.
Present the validated result in a clear table; use a chart when comparison helps the audience. Continue with original Pass-IT practice questions and explanations to examine why plausible preparation rules produce different answers.